SEOClerks


santoshbimali has no services


You need to install PES PRO script. You need to provide PES PRO Script. It ...

php script web

I need a simple baisc web application. Where users can come and Signup and ...

web developm

Dear Bidder, I am looking for a simple programmed website. Let s Discuss. O...

Web Developm

I want to make a Simple Dynamic Website. See below sample of the website I ...

Website Web Webdesig

I need to make a Website. it s like a gaming site. Details will be provided...

Website Web Webdesig

Dear All, I need 100000 Youtube Views within 7-8 Days. Can you provide? I n...

You Youtube

If you can t provide me first please don t bid. You need to provide me 4K y...

Youtubes Youtubea Youtubes

Buyer Reviews


Recommendations


Statuses


Order Now
Process Time: 0.052232980728149

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

SELECT * FROM seoclerks.members WHERE username='santoshbimali' AND status='1' 1SELECT * FROM seoclerks.members WHERE username='santoshbimali' AND status='1'

/opt/clerks-staging/docroot/user.php 54 () ()

SELECT * FROM seoclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

SELECT * FROM seoclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE affiliateUserId = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

SELECT * FROM seoclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

SELECT * FROM codeclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE seller_USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

SELECT * FROM codeclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE affiliateUserId = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

SELECT * FROM codeclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

SELECT * FROM listingdock.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE seller_USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

SELECT * FROM listingdock.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE affiliateUserId = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

SELECT * FROM listingdock.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

SELECT * FROM pixelclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE seller_USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

SELECT * FROM pixelclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE affiliateUserId = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

SELECT * FROM pixelclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

SELECT * FROM wordclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE seller_USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

SELECT * FROM wordclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE affiliateUserId = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

SELECT * FROM wordclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE USERID = ?

/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

UPDATE seoclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'1UPDATE seoclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'1UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'1UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'1UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'1UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1594646935,\"userTypeUpdated\":1772572835,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385876'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

SELECT * FROM seoclerks.members WHERE USERID='385876'1SELECT lastlogin FROM seoclerks.members WHERE USERID='385876'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays()

SELECT * FROM posts WHERE USERID=3858761SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=385876

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM follow F, members M WHERE F.FOLLOWING=385876 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.FOLLOWING=385876 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()

SELECT * FROM follow F, members M WHERE F.USERID=385876 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.FOLLOWING AS USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.USERID=385876 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()

SELECT * FROM follow WHERE FOLLOWING=3858761SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=385876

/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()

SELECT * FROM follow WHERE USERID=3858761SELECT COUNT(FID) AS total FROM follow WHERE USERID=385876

/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()

SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99 1SELECT count(A.PID) AS total FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 1SELECT A.*, C.userlevel, C.username, C.ip, C.lip, C.profilepicture FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? 1SELECT count(A.wantid) AS total FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 401SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM wantbids WHERE active=1 AND wantid='72807'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72807'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='design'1SELECT name FROM categories_wanttotrade WHERE seo='design'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()

SELECT * FROM wantbids WHERE active=1 AND wantid='72681'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72681'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='Web20'1SELECT name FROM categories_wanttotrade WHERE seo='Web20'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()

SELECT * FROM wantbids WHERE active=1 AND wantid='72657'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72657'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='shared-webhosting'1SELECT name FROM categories_wanttotrade WHERE seo='shared-webhosting'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()

SELECT * FROM wantbids WHERE active=1 AND wantid='62757'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62757'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM wantbids WHERE active=1 AND wantid='62598'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62598'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM wantbids WHERE active=1 AND wantid='52116'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52116'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='youtube'1SELECT name FROM categories_wanttotrade WHERE seo='youtube'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()

SELECT * FROM wantbids WHERE active=1 AND wantid='31005'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31005'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC1SELECT count(A.tradeid) AS total FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 401SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 10

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 10

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 10

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='385876' ORDER BY A.lastgigedit DESC LIMIT 10

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 11SELECT time FROM inbox2 WHERE MSGFROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1

/opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()

SELECT * FROM seoclerks.ratings WHERE USERID='385876' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='385876' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM codeclerks.ratings WHERE USERID='385876' AND PID != 01SELECT good, bad FROM codeclerks.ratings WHERE USERID='385876' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM listingdock.ratings WHERE USERID='385876' AND PID != 01SELECT good, bad FROM listingdock.ratings WHERE USERID='385876' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM pixelclerks.ratings WHERE USERID='385876' AND PID != 01SELECT good, bad FROM pixelclerks.ratings WHERE USERID='385876' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM wordclerks.ratings WHERE USERID='385876' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='385876' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.1751701SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Polymer%' OR A.skills LIKE '%Polymer%') ORDER BY A.lastgigedit desc LIMIT 0,400.1751700.175170
0.1590991SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Auction%' OR A.skills LIKE '%Auction%') ORDER BY A.lastgigedit desc LIMIT 0,400.1590990.159099
0.1298701SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Polymer%' OR A.skills LIKE '%Polymer%')0.1298700.129870
0.1221851SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Slider%' OR A.skills LIKE '%Slider%')0.1221850.122185