Home
From USD
50
Full-Day Beijing City tour
Architecture Tour
History Tour
Sightseeing Tour
Explore Beijing city this entire day. Visit the world-famous sights of the Great Wall, the Forbidden City, Temple of Heaven, and ...
View More
From USD
30
Full-Day Beijing tour
Culture Tour
History Tour
Sightseeing Tour
Explore Beijing this entire day. Visit the Badaling and Mutianyu sections of the Great Wall, Summer Palace, the Temple of Heaven, ...
View More
Contributed By Roseanne Su
(SELECT distinct(b.id),b.clicks,b.impmade,b.custombannercode FROM banners as b join banner_pages_id as bp on bp.banner_id = b.id join banner_location_id as bli on bli.banner_id = b.id
where b.status=1 and b.rejected=0 and bp.page_id=4 and bli.type_id=2 and b.publish_up <= now() and b.publish_down>=now()
and ((bli.country_id = '220') and (bli.city_id = '1032' or bli.city_id=0)))
UNION (SELECT distinct(b.id),b.clicks,b.impmade,b.custombannercode FROM banners as b join banner_pages_id as bp on bp.banner_id = b.id join banner_location_id as bli on bli.banner_id = b.id
where b.status=1 and b.rejected=0 and type_id=1 and bp.page_id=4 and b.publish_up <= now() and b.publish_down>=now()
and ((bli.country_id = '45') and (bli.city_id = '2075' or bli.city_id=0))) ORDER BY RAND() Limit 1