| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=776153 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=776153
| /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='945524' | 1 | SELECT * FROM seoclerks.members WHERE USERID='945524'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='776153' 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='776153'
AND A.RATER=B.USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM orders WHERE PID='776153' 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='776153'
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='776153' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='776153'
| /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='945524' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='945524' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='945524' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='945524' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='945524' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='945524' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='945524' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='945524' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='945524' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='945524' 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()
|
ata EntryData MiningExcel Data EntryCRM Data EntryData ScrapingCopy Paste WorkData ConversionPDF to Excel or WordJPEG to Excel or WordTyping in Excel or WordBusiness Card EntryShopify Data EntryWordPress Data EntryE-commerce Products ListingWeb Research and Web ScrappingData Collection from Linkedln/InstagramProperty Research, Public Record SearchReal Estate Research and Data Entry (Name, Email, Phone, Address, etc)Please contact me first before placing an order to check the Availability and price Estimate of your project.Thank you.
