DB Error: selectList query failed
SELECT SQL_CALC_FOUND_ROWS DISTINCT jedu2_tours.*, jedu2_tours.id AS code, jedu2_trip_departures.value_cs AS departure_from, entities.name AS agency_name, jedu2_trip_transport_types.value_cs AS transport_type, jedu2_dates_prices.price AS min_price, jedu2_dates_prices.min_date, jedu2_dates_prices.max_date, jedu2_image.full_name AS image, jedu2_tours.summary AS meta_description, jedu2_hotel_board.value_cs AS board FROM jedu2_tours LEFT JOIN jedu2_trip_departures ON jedu2_tours.departure_from_id = jedu2_trip_departures.id LEFT JOIN entities ON jedu2_tours.agency_id = entities.id LEFT JOIN jedu2_trip_transport_types ON jedu2_tours.transport_id = jedu2_trip_transport_types.id LEFT JOIN jedu2_tour_countries ON jedu2_tour_countries.tour_id = jedu2_tours.id LEFT JOIN (SELECT tour_id, MIN( jedu2_tour_variant_dates.from) AS min_date, MAX( jedu2_tour_variant_dates.to) AS max_date, MIN( jedu2_tour_variant_dates.price) AS price FROM jedu2_tour_variants LEFT JOIN jedu2_tour_variant_dates ON jedu2_tour_variants.id = jedu2_tour_variant_dates.variant_id GROUP BY jedu2_tour_variants.tour_id) AS jedu2_dates_prices ON jedu2_tours.id = jedu2_dates_prices.tour_id LEFT JOIN (SELECT object_id, file_id, CONCAT(name, '.', ext) AS full_name FROM jedu2_file_attachments LEFT JOIN jedu2_files ON jedu2_files.id = jedu2_file_attachments.file_id WHERE channel_id = 5 AND main = 1) AS jedu2_image ON jedu2_tours.id = jedu2_image.object_id LEFT JOIN jedu2_hotel_board ON jedu2_hotel_board.id = jedu2_tours.board_id WHERE (published = 1) AND jedu2_tours.id IN (SELECT tour_id FROM jedu2_tour_countries WHERE country_id = '202')ORDER BY created DESC, created DESC LIMIT 0, 5
Got error 28 from storage engine