SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
Google Map edit to a local listing Max $2

Need a local google guide account holder whose map edits happen instantly. ...

  • Fourfour
    Fourfour Level 1
    • google maps local
    FPS AndroiDGame-Bot NEEDED Max $35

    Looking for someone with experience with Android Games Specifications : und...

  • V12E98
    V12E98 Level 1
    • Programm Script Scripts
    easy money making method URGENT Max $12

    I need a way to quickly make 600 Dollars within a week s time. Method must ...

  • ghostman20
    ghostman20 Level 1
    • Money
    Google Adwords Complete Guide Max $7

    I am in need of a COMPLETE tutorial stepbystep guide for google adwords mar...

  • Robeman
    Robeman Level 1
    • Seo Marketin Affiliat
    Looking for Website E book Max $7

    I am seeking a MASSIVE ebook on creating websites with html or wordpress. T...

  • Robeman
    Robeman Level 1
    • Programm Websites Seo
    Pokemon GO cheats, ebook, guide Max $5

    Pokemon GO! What do u know about pokemon GO, and what can u create for me a...

  • ivcis
    ivcis Level 1
    • Ebook Articlew Game
    Show Me A Method to Win Any Penny Auction Quickly Max $10

    I would like someone to teach me a method to win penny auctions perhaps to ...

  • DeathGFx
    DeathGFx Level 1
    • Hacking Auctions Pennyauc
    Promote free Wordpress Ebook Max $10

    Hello freelancers. :- I m e-book writer and created a blog e-book for newbi...

  • Maillistseller
    Maillistseller Level 1
    • Marketin Seo Blackhat
    Rewrite 60 - 80 page Social Media Ebooks Max $80

    I am looking for someone who will rewrite a number of social media eBooks r...

  • tongo1423
    tongo1423 Level 1
    • Writing Social Media
    Real Safe Youtube Views drip feed slow 100 money bac... Max $25

    Youtube has been REJECTING videos and I need a new way to get views SAFELY ...

  • soundviewclerks
    soundviewclerks Level 1
    • Youtube Guidelin Reject
    Recover Hotmail password Max $60

    Hello Everyone ....I want to recover hotmail password ... Please help me in...

  • cody
    cody Level 1
    • Proffess possible recover
    add our internet radio station to different online l... Max $5

    Hi, i m looking for someone who could add our internet radio station to all...

  • EROPanama
    EROPanama Level 1

    • Order Now
    Process Time: 0.39224791526794

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * 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 '%guide%' OR A.skills LIKE '%guide%')1SELECT 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 '%guide%' OR A.skills LIKE '%guide%')

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

    SELECT * 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 '%guide%' OR A.skills LIKE '%guide%') ORDER BY A.lastgigedit desc LIMIT 0,401SELECT 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 '%guide%' OR A.skills LIKE '%guide%') ORDER BY A.lastgigedit desc LIMIT 0,40

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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
    10.7012661SELECT 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 (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Whiteseo%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 4010.70126610.701266
    0.7744831SELECT 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 (37) AND gtags like'%Image%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.7744830.774483
    0.6014411SELECT 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 (37) AND gtags like'%Image%' AND type !=99 0.6014410.601441
    0.5523831SELECT 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 (87) AND gtags like'%internet%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5523830.552383
    0.4933571SELECT 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 (22) AND gtags like'%Expert%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4933570.493357
    0.4873051SELECT 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 (22) AND gtags like'%Human%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4873050.487305
    0.4194801SELECT 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 (15) AND gtags like'%Channel%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4194800.419480
    0.1684551SELECT 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 '%guide%' OR A.skills LIKE '%guide%') ORDER BY A.lastgigedit desc LIMIT 0,400.1684550.168455
    0.1432081SELECT 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 '%guide%' OR A.skills LIKE '%guide%')0.1432080.143208