select count(userid) as adscount from ap_user where (city_id=1 or city='Lahore' or city='lahore') and dealer='Y'
| |
Car Dealers in Lahore (66) |
select count(userid) as adscount from ap_user where (city_id=2 or city='Karachi' or city='karachi') and dealer='Y'
|
Car Dealers in Karachi (140) |
select count(userid) as adscount from ap_user where (city_id=3 or city='Islamabad' or city='islamabad') and dealer='Y'
|
Car Dealers in Islamabad (29) |
select count(userid) as adscount from ap_user where (city_id=4 or city='Faisalabad' or city='faisalabad') and dealer='Y'
|
Car Dealers in Faisalabad (8) |
select count(userid) as adscount from ap_user where (city_id=5 or city='Multan' or city='multan') and dealer='Y'
|
Car Dealers in Multan (3) |
select count(userid) as adscount from ap_user where (city_id=6 or city='Peshawar' or city='peshawar') and dealer='Y'
|
Car Dealers in Peshawar (10) |
select count(userid) as adscount from ap_user where (city_id=7 or city='Rawalpindi' or city='rawalpindi') and dealer='Y'
|
Car Dealers in Rawalpindi (11) |
select count(userid) as adscount from ap_user where (city_id=8 or city='Quetta' or city='quetta') and dealer='Y'
|
Car Dealers in Quetta (6) |
select count(userid) as adscount from ap_user where (city_id=9 or city='Hyderabad' or city='hyderabad') and dealer='Y'
|
Car Dealers in Hyderabad (3) |
select count(userid) as adscount from ap_user where (city_id=10 or city='Sialkot' or city='sialkot') and dealer='Y'
|
Car Dealers in Sialkot (4) |
select count(userid) as adscount from ap_user where (city_id=11 or city='Hafizabad' or city='hafizabad') and dealer='Y'
|
Car Dealers in Hafizabad (0) |
select count(userid) as adscount from ap_user where (city_id=12 or city='Bahawalpur' or city='bahawalpur') and dealer='Y'
|
Car Dealers in Bahawalpur (0) |
select count(userid) as adscount from ap_user where (city_id=13 or city='Sheikhupura' or city='sheikhupura') and dealer='Y'
|
Car Dealers in Sheikhupura (1) |
select count(userid) as adscount from ap_user where (city_id=14 or city='Gujranwala' or city='gujranwala') and dealer='Y'
|
Car Dealers in Gujranwala (4) |
select count(userid) as adscount from ap_user where (city_id=15 or city='Wazirabad' or city='wazirabad') and dealer='Y'
|
Car Dealers in Wazirabad (0) |
select count(userid) as adscount from ap_user where (city_id=16 or city='Abbottabad' or city='abbottabad') and dealer='Y'
|
Car Dealers in Abbottabad (1) |
select count(userid) as adscount from ap_user where (city_id=19 or city='Jehlum' or city='jehlum') and dealer='Y'
|
Car Dealers in Jehlum (0) |
select count(userid) as adscount from ap_user where (city_id=20 or city='Mansehra' or city='mansehra') and dealer='Y'
|
Car Dealers in Mansehra (3) |
select count(userid) as adscount from ap_user where (city_id=21 or city='Dubai U.A.E' or city='dubai u.a.e') and dealer='Y'
|
Car Dealers in Dubai U.A.E (0) |
select count(userid) as adscount from ap_user where (city_id=22 or city='Montreal' or city='montreal') and dealer='Y'
|
Car Dealers in Montreal (0) |
select count(userid) as adscount from ap_user where (city_id=23 or city='Nowshehra' or city='nowshehra') and dealer='Y'
|
Car Dealers in Nowshehra (0) |
select count(userid) as adscount from ap_user where (city_id=24 or city='Swat' or city='swat') and dealer='Y'
|
Car Dealers in Swat (0) |
select count(userid) as adscount from ap_user where (city_id=25 or city='Sahiwal' or city='sahiwal') and dealer='Y'
|
Car Dealers in Sahiwal (1) |
select count(userid) as adscount from ap_user where (city_id=26 or city='Attock' or city='attock') and dealer='Y'
|
Car Dealers in Attock (1) |
select count(userid) as adscount from ap_user where (city_id=27 or city='Mirpur (A.K)' or city='mirpur (a.k)') and dealer='Y'
|
Car Dealers in Mirpur (A.K) (0) |
select count(userid) as adscount from ap_user where (city_id=28 or city='Jhang' or city='jhang') and dealer='Y'
|
Car Dealers in Jhang (0) |
select count(userid) as adscount from ap_user where (city_id=29 or city='Sakhar' or city='sakhar') and dealer='Y'
|
Car Dealers in Sakhar (0) |
select count(userid) as adscount from ap_user where (city_id=30 or city='Gujrat' or city='gujrat') and dealer='Y'
|
Car Dealers in Gujrat (2) |
select count(userid) as adscount from ap_user where (city_id=31 or city='Burewala' or city='burewala') and dealer='Y'
|
Car Dealers in Burewala (0) |
select count(userid) as adscount from ap_user where (city_id=32 or city='Bahawalnagar' or city='bahawalnagar') and dealer='Y'
|
Car Dealers in Bahawalnagar (0) |
select count(userid) as adscount from ap_user where (city_id=33 or city='London' or city='london') and dealer='Y'
|
Car Dealers in London (0) |
select count(userid) as adscount from ap_user where (city_id=34 or city='Talagang' or city='talagang') and dealer='Y'
|
Car Dealers in Talagang (0) |
select count(userid) as adscount from ap_user where (city_id=35 or city='D. I. Khan' or city='d. i. khan') and dealer='Y'
|
Car Dealers in D. I. Khan (0) |
select count(userid) as adscount from ap_user where (city_id=36 or city='Wah Cantt' or city='wah cantt') and dealer='Y'
|
Car Dealers in Wah Cantt (3) |
select count(userid) as adscount from ap_user where (city_id=37 or city='Kasur' or city='kasur') and dealer='Y'
|
Car Dealers in Kasur (1) |
select count(userid) as adscount from ap_user where (city_id=38 or city='Khushab' or city='khushab') and dealer='Y'
|
Car Dealers in Khushab (1) |
select count(userid) as adscount from ap_user where (city_id=39 or city='Sargodha' or city='sargodha') and dealer='Y'
|
Car Dealers in Sargodha (4) |
select count(userid) as adscount from ap_user where (city_id=40 or city='Kohat' or city='kohat') and dealer='Y'
|
Car Dealers in Kohat (1) |
select count(userid) as adscount from ap_user where (city_id=41 or city='Birmingham(UK)' or city='birmingham(uk)') and dealer='Y'
|
Car Dealers in Birmingham(UK) (0) |
select count(userid) as adscount from ap_user where (city_id=42 or city='Kharian Cantt.' or city='kharian cantt.') and dealer='Y'
|
Car Dealers in Kharian Cantt. (0) |
select count(userid) as adscount from ap_user where (city_id=43 or city='Haripur (Hazara)' or city='haripur (hazara)') and dealer='Y'
|
Car Dealers in Haripur (Hazara) (0) |
select count(userid) as adscount from ap_user where (city_id=44 or city='Sadiqabad' or city='sadiqabad') and dealer='Y'
|
Car Dealers in Sadiqabad (0) |
select count(userid) as adscount from ap_user where (city_id=45 or city='Glasgow (UK)' or city='glasgow (uk)') and dealer='Y'
|
Car Dealers in Glasgow (UK) (0) |
select count(userid) as adscount from ap_user where (city_id=46 or city='Vehari' or city='vehari') and dealer='Y'
|
Car Dealers in Vehari (0) |
select count(userid) as adscount from ap_user where (city_id=47 or city='UK' or city='uk') and dealer='Y'
|
Car Dealers in UK (1) |
select count(userid) as adscount from ap_user where (city_id=48 or city='Sarai Alamgir' or city='sarai alamgir') and dealer='Y'
|
Car Dealers in Sarai Alamgir (0) |
select count(userid) as adscount from ap_user where (city_id=49 or city='Mardan' or city='mardan') and dealer='Y'
|
Car Dealers in Mardan (0) |
select count(userid) as adscount from ap_user where (city_id=50 or city='Moscow' or city='moscow') and dealer='Y'
|
Car Dealers in Moscow (0) |
select count(userid) as adscount from ap_user where (city_id=51 or city='Osaka' or city='osaka') and dealer='Y'
|
Car Dealers in Osaka (0) |
select count(userid) as adscount from ap_user where (city_id=52 or city='Kamra' or city='kamra') and dealer='Y'
|
Car Dealers in Kamra (0) |
select count(userid) as adscount from ap_user where (city_id=53 or city='Khanewal' or city='khanewal') and dealer='Y'
|
Car Dealers in Khanewal (0) |
select count(userid) as adscount from ap_user where (city_id=54 or city='Gilgit' or city='gilgit') and dealer='Y'
|
Car Dealers in Gilgit (0) |
select count(userid) as adscount from ap_user where (city_id=55 or city='Kotli Azad Kashmir' or city='kotli azad kashmir') and dealer='Y'
|
Car Dealers in Kotli Azad Kashmir (0) |
select count(userid) as adscount from ap_user where (city_id=56 or city='Hyderabad India' or city='hyderabad india') and dealer='Y'
|
Car Dealers in Hyderabad India (0) |
select count(userid) as adscount from ap_user where (city_id=57 or city='Larkana' or city='larkana') and dealer='Y'
|
Car Dealers in Larkana (0) |
select count(userid) as adscount from ap_user where (city_id=58 or city='Lasbela' or city='lasbela') and dealer='Y'
|
Car Dealers in Lasbela (0) |
select count(userid) as adscount from ap_user where (city_id=59 or city='Arif Wala' or city='arif wala') and dealer='Y'
|
Car Dealers in Arif Wala (0) |
select count(userid) as adscount from ap_user where (city_id=60 or city='Toba Tek Singh' or city='toba tek singh') and dealer='Y'
|
Car Dealers in Toba Tek Singh (0) |
select count(userid) as adscount from ap_user where (city_id=61 or city='Rahim Yar Khan' or city='rahim yar khan') and dealer='Y'
|
Car Dealers in Rahim Yar Khan (0) |
select count(userid) as adscount from ap_user where (city_id=62 or city='Mianwali' or city='mianwali') and dealer='Y'
|
Car Dealers in Mianwali (0) |
select count(userid) as adscount from ap_user where (city_id=63 or city='Okara' or city='okara') and dealer='Y'
|
Car Dealers in Okara (2) |
