select al.*,a.* from tbl_tours t join tbl_countries cn on t.tour_starting_country=cn.countries_iso_code_2 left join tbl_locations l on t.tour_starting_city=l.location_id LEFT JOIN tbl_character_area_locations al ON l.location_id = al.al_location_id LEFT JOIN tbl_character_location_areas a ON a.area_id = al.al_area_id left join tbl_suppliers sp on t.tour_supplier_id=sp.supplier_id where tour_category NOT IN (1,3) and tour_id in (select distinct(season_tour_id) from tbl_tour_season_pricing where (year(season_start_date) = '2025' or year(season_end_date) = '2025') and season_status='Active') and tour_status='Active' and available_on_library='Yes' and FIND_IN_SET ('1', tour_websites) and (a.area_id IN (select DISTINCT (area_id) from tbl_locations l LEFT JOIN tbl_character_area_locations al ON l.location_id = al.al_location_id LEFT JOIN tbl_character_location_areas a ON a.area_id = al.al_area_id where a.area_status='Active' and l.location_status='Active' and area_country_id='SQ' and al_location_id is NOT NULL ) ) GROUP BY al_area_id order by area_name asc