| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=750372 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=750372
| /opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()
|
| SELECT * FROM categories | 1 | SELECT * FROM categories
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| SELECT * FROM seoclerks.members WHERE USERID='921191' | 1 | SELECT * FROM seoclerks.members WHERE USERID='921191'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='750372' AND A.RATER=B.USERID | 1 | SELECT COUNT(A.RID) as total,
SUM(bad) as badTotal,
SUM(good) as goodTotal
FROM
ratings A,
seoclerks.members B
WHERE A.PID='750372'
AND A.RATER=B.USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM orders WHERE PID='750372' AND status in (1, 4, 6) | 1 | SELECT
OID,
stime,
extradays1,
extradays2,
extradays3,
extra1ordered,
extra2ordered,
extra3ordered,
days,
status,
quantity,
extras_data
FROM
orders
WHERE PID='750372'
AND status in (1, 4, 6)
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| UPDATE posts SET viewcount = viewcount + 1 WHERE PID='750372' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='750372'
| /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='921191' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='921191' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='921191' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='921191' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='921191' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='921191' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='921191' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='921191' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='921191' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='921191' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
|
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
|
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
|
| SELECT * FROM categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()
|
| SELECT * FROM seoclerks.members WHERE USERID=? | 1 | SELECT usergroup
FROM seoclerks.members
WHERE USERID=?
| /opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()
|
I am Muhammad Bilal.Welcome to my offer page. I can help you to collect thousands of data According to your niche from yellow pages either from search or you could provide me bunch of yellow pages URLs and i can extract all the data from there. Scraped data can be delivered in CSV or Excel or SQLite 3 database or even I can import that in another data source if you want.My Services: -Scrape Yellow pages the USAScrape Yellow Pages Canada.Scrape Yellow Page Australia.Scrape Yellow Pages Dubai And Many More.I will provide verified data records as per the client's targeted keyword/industry and place. 
