SEOClerks


rannynm has no services


How long would it take for you to improve my Alexa ranking? my site is http...

  • rannynm
    rannynm Level 3
  • Alexa alexaran ranking

    Can you help improve my Alexa ranking? It is currently at 655,000 worldwide...

  • rannynm
    rannynm Level 3
  • Alexa SEO

    Our Alexa ranking is currently at 205,000 globally. We need to get it down ...

  • rannynm
    rannynm Level 3
  • Alexa traffic social

    I need 20,000 visitors to an article on my website, complete in no less tha...

  • rannynm
    rannynm Level 3
  • Traffic Seo

    I need 10K views for 10, completed within 36 hours of an online video Pleas...

  • rannynm
    rannynm Level 3
  • youtube views traffic

    We need 1200 Y Tb subs, actual people, USA, not bots, delivered within 24 -...

  • rannynm
    rannynm Level 3
  • Subscrib Youtubes

    We need 500 Y Tb subs, actual people, USA, not bots, delivered within 24 - ...

  • rannynm
    rannynm Level 3
  • Subscrib Youtubes

    We need 500 Y Tb subs, actual people, USA, not bots, delivered within 24 - ...

  • rannynm
    rannynm Level 3
  • Youtubes

    Can you deliver y t views? Can you deliver? 10,000 for 10, split between up...

  • rannynm
    rannynm Level 3
  • Traffic Ytviewsi

    Can you deliver y-t views? Can you deliver? 10,000 for 10, split between up...

  • rannynm
    rannynm Level 3
  • Socialme Youtubev

    I need someone to provide me with 5K YouTube views per video on a regular b...

  • rannynm
    rannynm Level 3
  • Youtubev

    I need 2,000 YouTube subscribers within 72 hours. Real, no bots, absolutely...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubes

    I need 2,000 YouTube subscribers within 48 hours. Real, no bots, absolutely...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubea Youtubes

    I need 50K page views of am article I have written. Need complete with 24 h...

  • rannynm
    rannynm Level 3
  • Facebook Safe traffic

    I need 50K views of my article on Huffington Post. Real people, not bots, E...

  • rannynm
    rannynm Level 3
  • Safe Traffic Adsense

    I need 50,000 visitors to an article on Huffington Post, complete as soon a...

  • rannynm
    rannynm Level 3
  • Traffic Seo Youtubes

    I need 3,000 views each of 5 different youtube videos. Can pay 2 each but n...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubes Youtubea

    I need 10,000 youtube subscribers. US, UK, Canada. English speaking countri...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubea Youtubes

    I need 10,000 views of my article on Huffington Post within 48 hours. Real ...

  • rannynm
    rannynm Level 3
  • Articles Traffic

    I need 10,000 views to an article on Huffington Post. Real people, English ...

  • rannynm
    rannynm Level 3
  • Viewers Articles

    I need 2,000 youtube views, no bots, no drops, complete in 24 hours. U.S., ...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubes

    I need 10,000 youtube subscribers. US, UK, Canada. English speaking countri...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubes Youtubea

    I need 1,000 views, 100 likes, 50 comments of this youtube video: https: ww...

  • rannynm
    rannynm Level 3
  • Youtubes Youtubea Youtubes

    I need 10,000 views of my article within the next 2 days. Real people, no b...

  • rannynm
    rannynm Level 3
  • Safe traffic adsense

    I need 5,000 views to my internet radio show. I need teens and family audie...

  • rannynm
    rannynm Level 3
  • Seo Traffic Follower

    I need 10,000 youtube subscribers, actual real people, no bots and no drops...

  • rannynm
    rannynm Level 3
  • Youtubea Youtubes Youtubes

    I need 50,000 youtube subscribers, no drop, no bots. I need this fulfilled ...

  • rannynm
    rannynm Level 3
  • Youtubes

    Buyer Reviews


    Recommendations


    Statuses


    Order Now
    Process Time: 0.17407202720642

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='rannynm' AND status='1' 1SELECT * FROM seoclerks.members WHERE username='rannynm' 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\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'1UPDATE seoclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'

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

    UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'1UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'

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

    UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'1UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'

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

    UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'1UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'

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

    UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'1UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1625304437,\"userBoostLoginUpdated\":1614874007,\"userTypeUpdated\":1772621402,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='385606'

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

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

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

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

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

    SELECT * FROM follow F, members M WHERE F.FOLLOWING=385606 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=385606 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=385606 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=385606 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=3856061SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=385606

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

    SELECT * FROM follow WHERE USERID=3856061SELECT COUNT(FID) AS total FROM follow WHERE USERID=385606

    /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='75778'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75778'

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

    SELECT * FROM categories_wanttotrade WHERE seo='Link-Building'1SELECT name FROM categories_wanttotrade WHERE seo='Link-Building'

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

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

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

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

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

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

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

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

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

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

    /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='63423'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63423'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM categories_wanttotrade WHERE seo='Audio-Music'1SELECT name FROM categories_wanttotrade WHERE seo='Audio-Music'

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

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

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

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

    /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='385606' 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='385606' 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='385606' 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='385606' 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='385606' 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='385606' 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='385606' 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='385606' 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='385606' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='385606' AND PID != 0

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

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

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

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

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

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

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

    SELECT * FROM wordclerks.ratings WHERE USERID='385606' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='385606' 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.4685661SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (64) AND gtags like'%vactor%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4685660.468566
    0.2743521SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (64) AND gtags like'%vactor%' AND type !=99 0.2743520.274352
    0.1782721SELECT 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 0.1782720.178272