select page_id from ctn_pages
where page_url = "ground-transportations" LIMIT 1
Array
(
[page_id] => 134
)
L
select g.*,a.asset_id,a.asset_file,a.asset_parent,a.asset_file_ext
from ctn_ground as g
left join ctn_tours_assets as a on a.asset_id = g.ground_photoSQl select g.*,a.asset_id,a.asset_file,a.asset_parent,a.asset_file_ext
from ctn_ground as g
left join ctn_tours_assets as a on a.asset_id = g.ground_photo order by g.display_order