SELECT tl_id, tl_code, tl_name_th, tl_fname_th, tl_abstract_th, tl_duration_day, tl_duration_night, tl_SPG_id, tl_location_th, tl_airline_code, tl_rating,tl_tags, tl_image_title, MinPrice
FROM tb_tour_lists tb1
INNER JOIN (
SELECT tpr_tl_id,
MIN(tpr_price_1ATwin_HT) MinPrice,
MAX(tpr_price_1ATwin_HT) MaxPrice
FROM tb_tour_prices tb1
INNER JOIN (
SELECT tp_tpr_id
FROM tb_tour_period
WHERE tp_enable = 'Y'
AND tp_deleted_at IS NULL
AND tp_date_of_departure > NOW()
) tb2 ON tb1.tpr_id = tb2.tp_tpr_id
WHERE tpr_enable = 'Y'
AND tpr_deleted_at IS NULL
GROUP BY tpr_tl_id
) tb2 ON tb1.tl_id = tb2.tpr_tl_id
WHERE tl_audit_status = 2
AND tl_publish = 'Y'
AND tl_deleted_at IS NULL
AND (
tl_location_en LIKE '%Morocco%'
OR
tl_location_th LIKE '%โมรอคโค%'
) AND tl_SPG_Id NOT LIKE '19'
GROUP BY tl_id
ORDER BY
MinPrice asc LIMIT 0, 20
ทัวร์โมรอคโค
