SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
I want you to make a report, blueprint and presentat... Max $2

I want you to make a report,blueprint and presentation on human activities ...

  • vivekkapil980
    vivekkapil980 Level 1
    • Articles Aritcle Contentw
    write post eview about my website on your website Max $3

    hello, i need some one to write review about my website his website, the we...

  • ocean398
    ocean398 Level 4
    • Contentw Websiter Articles

    Order Now
    Process Time: 0.25904893875122

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

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

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

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

    		/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
    0.1238801SELECT 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 '%Reviewwriting%' OR A.skills LIKE '%Reviewwriting%') ORDER BY A.lastgigedit desc LIMIT 0,400.1238800.123880
    0.1149551SELECT 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 '%Prlinks%' OR A.skills LIKE '%Prlinks%') ORDER BY A.lastgigedit desc LIMIT 0,400.1149550.114955
    0.1046531SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Fx%') ORDER BY total_recommendations desc LIMIT 0,400.1046530.104653
    0.1007751SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Doflow%') ORDER BY total_recommendations desc LIMIT 0,400.1007750.100775
    0.1004881SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%seoarticles%') ORDER BY total_recommendations desc LIMIT 0,400.1004880.100488
    0.0983081SELECT 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 '%Reviewwriting%' OR A.skills LIKE '%Reviewwriting%')0.0983080.098308
    0.0929951SELECT 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 '%Prlinks%' OR A.skills LIKE '%Prlinks%')0.0929950.092995