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

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 ( 1,15,17,16,18,14,21,19,20,24,25,26,23,28,30,27,31,33,32,34,10,37,9,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,73,71,70,72,74,76,78,77,69,79,80,81,83,82,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,116,115,117,118,119,120,121,122,123,124,125,126,127,128,130,132,131,134,129,135,136,137,138,139,142,140,143,141,145,146,150,151,158,160,162,163,164,166,169,170,171,173,175,176,177,178,180,179,181,202 ) 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