SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
Create Twitter Automation Application Max $75

create a software app that can do the following for Twitter: main descripti...

  • Shaghouri
    Shaghouri Level 2
    • Programm web applicat
    I Need Someone To Show Me How To Use MAC MS Remote D... Max $10

    i need someone to help me connect to microsoft remote desktop on my mac, or...

  • cpreiss
    cpreiss Level 1
    • ms remote desktop
    Simple app solution for adding files Max $30

    Hi i am looking for simple app solution to ease up process i am doing curre...

  • lazzycoD
    lazzycoD Level 1
    • Programm Coding Software
    Twain data source software Max $100

    What we need is an interface built to the TWAIN specification which is a .d...

  • pamila
    pamila Level 1
    • Laravel Php Programm
    Notification Desktop App to work on MAC and Windows Max $40

    Build a simple order notification app, we have an online shop, we want to g...

  • ekumahost
    ekumahost Level 1
    • Php Mysql Design
    creating Rainmeter theme for windows 7 desktop Max $15

    hello I am looking for someone who would be able to create me a theme Rainm...

  • subitositi
    subitositi Level 1
    • Design Designer
    I need a software to get appointments from my websit... Max $50

    hello i need a software for get appointment date from this web page http: i...

  • DoctorOfSeo
    DoctorOfSeo Level 1
    • C Php Net
    just need 20 images about San Bernadino shooting wit... Max $3

    I just need 20 images about San Bernadino shooting or peace and have 20 lin...

  • shahzaibcomsat
    shahzaibcomsat Level 1
    • Adobe Editing Pix
    I want a working VPS Max $2

    I want a working VPS that is compatible with mac or window. This VPS must b...

  • G1NGER1NVASION
    G1NGER1NVASION Level 1
    • vps computer server

    Order Now
    Process Time: 0.3184859752655

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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
    2.9572301SELECT 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'%Gsalinks%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 402.9572302.957230
    0.2000741SELECT 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 '%anything%' OR A.skills LIKE '%anything%') ORDER BY A.lastgigedit desc LIMIT 0,400.2000740.200074
    0.1513281SELECT 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 '%100%' OR A.skills LIKE '%100%') ORDER BY A.lastgigedit desc LIMIT 0,400.1513280.151328
    0.1453511SELECT 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 '%100%' OR A.skills LIKE '%100%')0.1453510.145351
    0.1451941SELECT 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 '%desktop%' OR A.skills LIKE '%desktop%') ORDER BY A.lastgigedit desc LIMIT 0,400.1451940.145194
    0.1285151SELECT 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 '%anything%' OR A.skills LIKE '%anything%')0.1285150.128515
    0.1234941SELECT 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 '%desktop%' OR A.skills LIKE '%desktop%')0.1234940.123494