SEOClerks

Clear
Sign In Join
All
Days left Views
Create New Job Showing page: 1 of 1
I'm looking for web scraper to download content from... Max $40

I m looking for a person who can donwload the 16 919 templates available in...

  • freelancer1
    freelancer1 Level 1
    • web scrappin download
    I need a email list of real estate agents in Eindhov... Max $5

    I need a email list of clients of people who need website real estate agent...

  • ahmetD
    ahmetD Level 1
    • Email scrappin
    Data Scraping Datamining from wikipedia and google m... Max $1

    I want some data extraction to be done for some places. I have a exel sheet...

  • nationalinfo
    nationalinfo Level 1
    • Datascra Exel Datamini
    UK email list needed Max $10

    Hi I want to purchase 5 millions of UK email list. Every email address has ...

  • GigaBusiness
    GigaBusiness Level 1
    • Email Lead Bulkmark
    Needed Email data base Max $10

    I am looking for a database of opt in email addresses in Switzerland. The r...

  • prindra
    prindra Level 1
    • Data Scrappin Email
    Bulk Email Marketing - provide target list & sen... Max $999

    Project Description: We are going to launch soon a networking & job vac...

  • Connectdirector
    Connectdirector Level 1
    • Emailscr Data Bulk
    I need 20,000 email ids, website addresses and phon... Max $2

    Hi, Am looking for a website scrapper to scrape email ids, website names an...

  • Candy0809
    Candy0809 Level 1
    • scraper Scraping scrappin
    Clipshare or PHPmotion list wanted Max $5

    Need PHPmotion or Clipshare list.

  • mqss
    mqss Level 1
    • scrappin

    Order Now
    Process Time: 0.35177898406982

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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.1330341SELECT 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'%buybacklinks%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.1330345.133034
    5.0608641SELECT 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'%Judibola%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.0608645.060864
    0.2237751SELECT 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 '%Marketing%' OR A.skills LIKE '%Marketing%') ORDER BY A.lastgigedit desc LIMIT 0,400.2237750.223775
    0.1758041SELECT 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 '%Organic%' OR A.skills LIKE '%Organic%') ORDER BY A.lastgigedit desc LIMIT 0,400.1758040.175804
    0.1728471SELECT 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 '%viral%' OR A.skills LIKE '%viral%') ORDER BY A.lastgigedit desc LIMIT 0,400.1728470.172847
    0.1706991SELECT 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 '%scrapping%' OR A.skills LIKE '%scrapping%') ORDER BY A.lastgigedit desc LIMIT 0,400.1706990.170699
    0.1475211SELECT 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 '%viral%' OR A.skills LIKE '%viral%')0.1475210.147521
    0.1393541SELECT 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 '%Organic%' OR A.skills LIKE '%Organic%')0.1393540.139354
    0.1335901SELECT 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 '%scrapping%' OR A.skills LIKE '%scrapping%')0.1335900.133590