1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE
ALGORITHM = UNDEFINED
DEFINER = `remote`@`%`
SQL SECURITY DEFINER
VIEW `lots_dispo` AS
SELECT DISTINCT
`l`.`lot_id` AS `lot_id`,
`l`.`lot_date` AS `lot_date`,
`l`.`lot_cachet` AS `lot_cachet`,
`l`.`lot_nb` AS `lot_nb`,
`l`.`lot_canal_id` AS `lot_canal_id`,
`l`.`lot_thc_id` AS `lot_thc_id`,
`l`.`lot_created` AS `lot_created`,
`l`.`lot_is_deleted` AS `lot_is_deleted`,
`l`.`lot_user_deleted` AS `lot_user_deleted`,
`l`.`lot_deleted` AS `lot_deleted`
FROM
(`lots` `l`
LEFT JOIN `lots_traitements` `lt` ON ((`l`.`lot_id` = `lt`.`lt_lot_id`)))
WHERE
((((SELECT MAX(`lt`.`lt_created`) where `l`.`lot_id` = `lt`.`lt_lot_id`) <> CAST(NOW() AS DATE))
AND (`lt`.`lt_close` = 0))
OR ISNULL(`lt`.`lt_lot_id`)) |
Partager