SEOClerks


johnjohn has no services


I need the Wordpress plugin WP Social SEO Booster Pro

  • johnjohn
    johnjohn Level 1
  • wordpres plugins

    I would like users to add link building, social network, or seo gigs to my ...

  • johnjohn
    johnjohn Level 1

  • I would like users to add link building, social network, or seo gigs to my ...

  • johnjohn
    johnjohn Level 1

  • I need one article per week written for my freelance site blog, blog dot pr...

  • johnjohn
    johnjohn Level 1

  • I would like users to add link building or seo gigs to my freelance site at...

  • johnjohn
    johnjohn Level 1

  • I m looking to have gigs added by other users to the Web Development and We...

  • johnjohn
    johnjohn Level 1

  • I need quality gigs added to my freelance site, programmerr.com. This can b...

  • johnjohn
    johnjohn Level 1

  • I need quality gigs added to my freelance site, programmerr.com. This can b...

  • johnjohn
    johnjohn Level 1

  • Programmerr.com Gigs for 5, 25, and 50 I am looking for to gigs to be creat...

  • johnjohn
    johnjohn Level 1

  • I m looking to expand my freelance site, programmerr.com. Programmerr allow...

  • johnjohn
    johnjohn Level 1
  • Buyer Reviews


    Recommendations


    Statuses


    Order Now
    Process Time: 0.060797929763794

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='johnjohn' AND status='1' 1SELECT * FROM seoclerks.members WHERE username='johnjohn' 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='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'1UPDATE seoclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'

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

    UPDATE codeclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'1UPDATE codeclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'

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

    UPDATE listingdock.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'1UPDATE listingdock.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'

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

    UPDATE pixelclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'1UPDATE pixelclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'

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

    UPDATE wordclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'1UPDATE wordclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1637014028,\"userTypeUpdated\":1772580711,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='7023'

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

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

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

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

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

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

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

    SELECT * FROM follow WHERE USERID=70231SELECT COUNT(FID) AS total FROM follow WHERE USERID=7023

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

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

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

    SELECT * FROM categories_wanttotrade WHERE seo='Social-Bookmarks'1SELECT name FROM categories_wanttotrade WHERE seo='Social-Bookmarks'

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

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

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

    SELECT * FROM categories_wanttotrade WHERE seo='Social-Networks'1SELECT name FROM categories_wanttotrade WHERE seo='Social-Networks'

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

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

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

    SELECT * FROM categories_wanttotrade WHERE seo='Article-Writing'1SELECT name FROM categories_wanttotrade WHERE seo='Article-Writing'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM wordclerks.ratings WHERE USERID='7023' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='7023' 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.2520301SELECT 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 (74) AND gtags like'%transfer%' AND type !=99 0.2520300.252030
    0.2295091SELECT 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 (51) AND gtags like'%microsoftexcel%' AND type !=99 0.2295090.229509