(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 = '124') and (bli.city_id = '1466' or bli.city_id=0))) ORDER BY RAND() Limit 1