SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
Need View & Click To My video Link Max $15

I have some link and i need click to my video & View The Video my video...

  • Atlmvp1
    Atlmvp1 Level 1
    • View See
    Looking For Hight Quality Backlinks Max $20

    Hi, Hope you are doing great! My name is Ranjith Chandran and i am the SEO ...

  • diamonddelight
    diamonddelight Level 1
    • Seerequi
    LIST ITEMS ON ETSY FOR ME Max $50

    I have 341 items on ebay that i need to be listed on my etsy shop please le...

  • FoxyPromotions
    FoxyPromotions Level 1
    • Ebay Etsy Seelisti
    Earn One now Easy job Banner click Max $1

    Hello my friends i have a very easy job for you First go here https: www.fa...

  • Php5
    Php5 Level 1
    • Adsensee
    Looking for Flash Game site manager Max $50

    Looking for an individual to manage my flash game site: www.zedigames.com B...

  • Benzedi
    Benzedi Level 1
    • Seerequi
    Improve the number of visitors on my website Max $50

    I have a website that promotes city-tours in Portugal, with low visitors nu...

  • jomalopes
    jomalopes Level 1
    • Socialne Seo Linkbuil
    Design 2 website+ reports assignment Max $150

    Hello , am looking to someone help me on my assignment . its 2 assignment. ...

  • flashlight
    flashlight Level 1
    • really good in
    I want 10000 Twiends seeds Max $10

    I want someone to make or sell me 10000 Twiends seeds. should be able to us...

  • TeenLife
    TeenLife Level 1
    • Make me 10000

    Order Now
    Process Time: 0.36133217811584

    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 '%see%' OR A.skills LIKE '%see%')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 '%see%' OR A.skills LIKE '%see%')

    		/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 '%see%' OR A.skills LIKE '%see%') 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 '%see%' OR A.skills LIKE '%see%') 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='36518'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36518'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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
    0.1327492SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600 0.0816440.051105

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.7893861SELECT 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 (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Contextualwiki%' AND type !=99 0.7893860.789386
    0.5010431SELECT 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'%Highdaguestpost%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5010430.501043
    0.4494201SELECT 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 (20) AND gtags like'%advert%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4494200.449420
    0.2591951SELECT 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 (46) AND gtags like'%English%' AND type !=99 0.2591950.259195
    0.2440751SELECT 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 (20) AND gtags like'%advert%' AND type !=99 0.2440750.244075
    0.1684431SELECT 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 '%see%' OR A.skills LIKE '%see%') ORDER BY A.lastgigedit desc LIMIT 0,400.1684430.168443
    0.1424921SELECT 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 '%see%' OR A.skills LIKE '%see%')0.1424920.142492
    0.0663752SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600 0.0816440.051105