SELECT DISTINCT pa.package_id as package_id,pa.package_name as package_name,pa.package_city as package_city,pa.package_image as package_image,
pa.package_cost as package_cost,pa.package_duration as package_duration,pa.package_tour as package_tour,pa.sub_category_name as sub_category_name,
pa.start_city as start_city, pa.end_city as end_city,pa.Accommodation as Accommodation,pa.Activities as Activities,pa.Breakfast as Breakfast,
pa.Guide as Guide,pa.Pickupanddrop as Pickupanddrop,pa.Transport as Transport,pa.package_itinerary as package_itinerary,
pa.package_overview as package_overview,pa.package_highlight as package_highlight,pa.package_status as package_status,ct.city_id as city_id,
ct.city_name as city_name,ct.city_image as city_image FROM package pa
LEFT JOIN tour tu ON pa.package_tour=tu.tour_id
LEFT JOIN city ct ON pa.package_city=ct.city_id
where pa.package_tour='' && pa.package_city = '' && pa.package_id = '' && pa.package_status='1'
