SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
Looking for Asian-Australian or Asian-American Male ... Max $10

Looking for Asian-Australian Asian-American Filipino-American male who can ...

  • choklatte
    choklatte Level 1
    • Must Speak English
    I want a video show /guide ways to reupload a video ... Max $6

    I want a video show guide ways to reupload a video bypass copyright success...

  • neyul
    neyul Level 1
    • Camtasia Youtubea Youtubes
    Post my link to 25 forums in Singapore. Max $10

    -I have a link that I want people in Singapore to be able to see. -People i...

  • tomtom7
    tomtom7 Level 1
    • Safe traffic adsense
    Looking for Writers for Asian article Niche. Max $5

    Im looking for writers to write about Asian niche. About what is going on i...

  • RichKind
    RichKind Level 1
    • Article Asian Writing
    Finance Article Writing and Publishing in Russian La... Max $5

    Russian Translation and computer skills task request. Writing and publishin...

  • Adir
    Adir Level 1
    • Russian Ukraine Kazakhst
    I need someone who can make me Twitter admin panel Max $80

    Hi, I need someone who can make me a indonasian twitter admin panel for fol...

  • paymentsofme
    paymentsofme Level 3
    • Php Twitter Admin
    Currently looking for a website designer. Max $59

    Currently looking for a website designer. The idea is to create several clo...

  • martstore1
    martstore1 Level 1
    • Website Design Designer
    Currently looking for a website designer Max $50

    Currently looking for a website designer. The idea is to create several clo...

  • martstore1
    martstore1 Level 1
    • Website Design Clone
    SEO/SEM implementation for website Max $15

    Looking for individual or team to start the SEO work on our website. As thi...

  • mashiro
    mashiro Level 1
    • Asia

    Order Now
    Process Time: 0.34725713729858

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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
    1.3438791SELECT 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'%blocommenting%' AND type !=99 1.3438791.343879
    0.6298871SELECT 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 (16) AND gtags like'%Increase%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.6298870.629887
    0.5027501SELECT 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 (46) AND gtags like'%3D%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5027500.502750
    0.1689541SELECT 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 '%Asia%' OR A.skills LIKE '%Asia%') ORDER BY A.lastgigedit desc LIMIT 0,400.1689540.168954
    0.1321851SELECT 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 '%Asia%' OR A.skills LIKE '%Asia%')0.1321850.132185