Database error: Invalid SQL: SELECT t.* , COUNT(*) AS cnt FROM (SELECT trt_tours.*, DATE_FORMAT(trt_tours.date_departure,'%a') AS ddow, DATE_FORMAT(trt_tours.date_arrival,'%a') AS adow, trt_tours.date_departure AS dd, (trt_tours.price1*28.8700+trt_tours.price2*1.0000+trt_tours.price3*34.6500)/1.0000 AS pr FROM trt_tours LEFT JOIN trt_tours_dates ON trt_tours.id = trt_tours_dates.tour_id WHERE 1=1 AND trt_tours.active=1 AND trt_tours.tour_type_id = 1 AND trt_tours.country_id IN (12) AND trt_tours.city_id IN (733) ORDER BY pr, dd) AS t GROUP BY t.hotel_id ORDER BY pr, dd LIMIT 0,8
MySQL Error: 2006 (MySQL server has gone away)
Session halted.