Bali Holiday Packages
Join to get the latest holiday
packages & special offers.
| Name | |
| Surname | |
| Submit | |
select holiday_detail.detail_id,holiday_detail.name as name,holiday_detail.overview as overview,
start_date,end_date,main_image,ref_code,special_yn,holiday_detail.description as description,accomm.name as accomm_name,
accomm.rating as accomm_rating,no_days,country,holiday_detail.seo_perma_link
from holiday_detail
inner join holiday_rel_portal
on holiday_detail.detail_id = holiday_rel_portal.detail_id
left join accomm
on holiday_detail.accomm_id = accomm.accomm_id
inner join location_country
on location_country.country_id = holiday_detail.country_id
where 1 AND (holiday_detail.country_id = "229" OR accomm.country_id = "229") AND portal_id = "114" AND display_yn = "1"
AND holiday_detail.active_yn = "1" AND end_date >= "2013-05-21"
order by field(holiday_detail.detail_id,)
limit 0,10
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
limit 0,10' at line 18
select holiday_detail.detail_id,holiday_detail.name as name,holiday_detail.overview as overview,
start_date,end_date,main_image,ref_code,special_yn,holiday_detail.description as description,accomm.name as accomm_name,
accomm.rating as accomm_rating,no_days,country,holiday_detail.seo_perma_link
from holiday_detail
inner join holiday_rel_portal
on holiday_detail.detail_id = holiday_rel_portal.detail_id
left join accomm
on holiday_detail.accomm_id = accomm.accomm_id
inner join location_country
on location_country.country_id = holiday_detail.country_id
where (holiday_detail.country_id = "229" OR accomm.country_id = "229") AND portal_id = "114" AND display_yn = "1"
AND holiday_detail.active_yn = "1" AND end_date >= "2013-05-21"
order by field(holiday_detail.detail_id,)
limit 0,10
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
limit 0,10' at line 18


| Name | |
| Surname | |
| Submit | |