Доставка блюд на дом

SELECT DISTINCT TM.id , TM.Title , TM.ServiceDiscount , TRB.DeliveryTime , TRD.DeliveryPrice , TM.MinOrder , TRD.OrderFrom AS FreeDeliveryMinOrder , TM.logo , TM.Partner , TM.Priority , TM.Rank , TM.DeliveryUpTime , GROUP_CONCAT( DISTINCT TR.Title SEPARATOR ', ' ) AS RatesString , DATE_FORMAT( DATE_ADD( DATE_ADD( CONCAT( DATE( NOW() ) , ' ' , TM.DeliveryCloseTime ) , INTERVAL +9 HOUR ) , INTERVAL -TRB.DeliveryTime MINUTE ) , '%H:%i' ) AS DeliveryCloseTime , kitchens.titles AS kitchens_titles , CASE /*WHEN TMn.published = 1 THEN 1*/ WHEN TMn.MenuShowType = 1 AND TMn.MenuDate >= DATE_FORMAT( NOW() , "%Y-%m-%d" ) AND TMn.published = 1 THEN 1 WHEN TMn.MenuShowType = 2 AND TMn.MenuDate <= DATE_FORMAT( NOW() , "%Y-%m-%d" ) AND TMn.published = 1 THEN 1 ELSE 0 END HaveMenu , TM.Class FROM t_ao_restaurant TM LEFT JOIN t_ao_restaurantkitchen TRK ON TM.id = TRK.id_restaurant LEFT JOIN ( SELECT TRK.id_restaurant , GROUP_CONCAT( TK.Title SEPARATOR ' /' ) AS titles FROM t_ao_restaurantkitchen TRK LEFT JOIN t_ao_kitchen TK ON TRK.id_kitchen = TK.id GROUP BY TRK.id_restaurant ) kitchens ON TM.id = kitchens.id_restaurant LEFT JOIN t_ao_menu TMn ON TM.id = TMn.id_restaurant LEFT JOIN t_ao_menukitchen TMK ON TMn.id = TMK.id_menu LEFT JOIN t_ao_menutype TMT ON TMn.id_menutype = TMT.id LEFT JOIN t_ao_restaurantborough TRB ON TM.id = TRB.id_restaurant LEFT JOIN t_ao_restaurantdelivery TRD ON TRB.id = TRD.id_restaurantborough LEFT JOIN t_ao_restaurantrate TRR ON TM.id = TRR.id_restaurant LEFT JOIN t_ao_rate TR ON TRR.id_rate = TR.id WHERE TM.published = 1 AND TRR.published = 1 AND TMn.published = 1 AND TM.Partner = 1 AND TRB.id_borough = 1 AND TRD.id = ( SELECT subTRD.id FROM t_ao_restaurantdelivery subTRD WHERE subTRD.id_restaurantborough = TRD.id_restaurantborough ORDER BY subTRD.OrderFrom DESC LIMIT 0,1 ) GROUP BY TM.id ORDER BY TM.Priority DESC , TM.Rank DESC , RAND() ASC , TM.Title ASC

SELECT DISTINCT TM.id , TM.Title , TM.ServiceDiscount , TRB.DeliveryTime , TRD.DeliveryPrice , TM.MinOrder , TRD.OrderFrom AS FreeDeliveryMinOrder , TM.logo , TM.Partner , TM.Priority , TM.Rank , TM.DeliveryUpTime , GROUP_CONCAT( DISTINCT TR.Title SEPARATOR ', ' ) AS RatesString , DATE_FORMAT( DATE_ADD( DATE_ADD( CONCAT( DATE( NOW() ) , ' ' , TM.DeliveryCloseTime ) , INTERVAL +9 HOUR ) , INTERVAL -TRB.DeliveryTime MINUTE ) , '%H:%i' ) AS DeliveryCloseTime , kitchens.titles AS kitchens_titles , CASE /*WHEN TMn.published = 1 THEN 1*/ WHEN TMn.MenuShowType = 1 AND TMn.MenuDate >= DATE_FORMAT( NOW() , "%Y-%m-%d" ) AND TMn.published = 1 THEN 1 WHEN TMn.MenuShowType = 2 AND TMn.MenuDate <= DATE_FORMAT( NOW() , "%Y-%m-%d" ) AND TMn.published = 1 THEN 1 ELSE 0 END HaveMenu , TM.Class FROM t_ao_restaurant TM LEFT JOIN t_ao_restaurantkitchen TRK ON TM.id = TRK.id_restaurant LEFT JOIN ( SELECT TRK.id_restaurant , GROUP_CONCAT( TK.Title SEPARATOR ' /' ) AS titles FROM t_ao_restaurantkitchen TRK LEFT JOIN t_ao_kitchen TK ON TRK.id_kitchen = TK.id GROUP BY TRK.id_restaurant ) kitchens ON TM.id = kitchens.id_restaurant LEFT JOIN t_ao_menu TMn ON TM.id = TMn.id_restaurant LEFT JOIN t_ao_menukitchen TMK ON TMn.id = TMK.id_menu LEFT JOIN t_ao_menutype TMT ON TMn.id_menutype = TMT.id LEFT JOIN t_ao_restaurantborough TRB ON TM.id = TRB.id_restaurant LEFT JOIN t_ao_restaurantdelivery TRD ON TRB.id = TRD.id_restaurantborough LEFT JOIN t_ao_restaurantrate TRR ON TM.id = TRR.id_restaurant LEFT JOIN t_ao_rate TR ON TRR.id_rate = TR.id WHERE TM.id IN ( 10 ) AND TM.published = 1 AND TRR.published = 1 AND TMn.published = 1 AND TM.Partner = 1 AND TRB.id_borough = 1 AND TRD.id = ( SELECT subTRD.id FROM t_ao_restaurantdelivery subTRD WHERE subTRD.id_restaurantborough = TRD.id_restaurantborough ORDER BY subTRD.OrderFrom DESC LIMIT 0,1 ) GROUP BY TM.id ORDER BY TM.Priority DESC , TM.Rank DESC , RAND() ASC , TM.Title ASC