FILE:
Error in query execution:Unknown column 'itt.duration' in 'order clause'Query:SELECT it.id,it.name,it.tour_tag,it.time_from,it.time_till,it.id_directory_name,it.special_offer ,it.page_url,it.overview,it.tour_highlights,it.page_url,it.destination_covered,it.grade,it.duration,it.time_till,it.time_from,dn.name dirname,images.url_small_img,images.url_large_img,images.alt_text,images.name as img_name FROM ((itineraries it LEFT JOIN itinerary_images AS itiImage ON it.id=itiImage.id_itinerary) LEFT JOIN images ON itiImage.id_image=images.id),directory_name dn,region_itineraries itt WHERE it.id=itt.itinerary_id AND itt.region_id="11" AND it.block<>"Y" AND it.id_directory_name=dn.id GROUP BY it.id ORDER BY itt.duration