SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
Datpiff Top 8 most played Max $10

I need bot traffic that can keep me in the top 8 on DatPiff all day and any...

  • UNCLEdope
    UNCLEdope Level 1
    • Traffic
    Need 100k fb followers for exchange with my well est... Max $1

    I want 100k fb likes for a fanpage along with 100k twitter followers in exc...

  • mansoors01
    mansoors01 Level 1
    • Good Social Presence
    Website page views needed in next 3 days Max $10

    Need website traffic in next 3 days for my website, please bid and tell me ...

  • faisalhaq
    faisalhaq Level 1
    • Website Pageview
    Help Me Get 1 or > CTR On My Blog Max $2

    Help me if you think it can be done to increase the CTR for increased earni...

  • blueseal
    blueseal Level 1
    • Adsense Placemtn Ctr
    Need 1 Millon traffic to my website Max $100

    hello there Need 1 Million traffic to my website within 5 days traffic fake...

  • cocoareviews
    cocoareviews Level 1
    • Traffic Facebook Adsence
    ads on Craigslist Max $10

    I need someone can post my ads on Craigslist.All ads in state of usa,uk and...

  • wolver
    wolver Level 1
    • Adsence
    Google play app downloads Max $20

    I need 20000 downloads of android app from google play, the application is ...

  • frankyy128
    frankyy128 Level 1
    • sence
    Analyze the " Online Presence Max $10

    I am interested in a report that will analyze the Online Presence . Includi...

  • iwantpage1
    iwantpage1 Level 1
    • seo research
    sign up for 40 blog/my page services Max $4

    PLEASE NOTE THAT YOU DO NOT NEED TO CREATE THE CONTENT OF THE BLOGS, JUST F...

  • sesile
    sesile Level 1
    • internet common sence

    Order Now
    Process Time: 0.37680411338806

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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
    5.4091401SELECT 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 (23,48,53,103) AND gtags like'%se%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.4091405.409140
    0.4075141SELECT 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 (93) AND gtags like'%ebookdescription%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4075140.407514
    0.2841841SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=610.2841840.284184
    0.1794641SELECT 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 '%sence%' OR A.skills LIKE '%sence%') ORDER BY A.lastgigedit desc LIMIT 0,400.1794640.179464
    0.1430881SELECT 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 '%sence%' OR A.skills LIKE '%sence%')0.1430880.143088
    0.1216781SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%HighDAPA%') ORDER BY total_recommendations desc LIMIT 0,400.1216780.121678
    0.1170851SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%singing%') ORDER BY total_recommendations desc LIMIT 0,400.1170850.117085
    0.0730991SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='tips-tricks' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 480, 400.0730990.073099