SEOClerks

Answers from user Promodrone

Showing page: 1 of 1

Why is no one buying my gig? I promoted it and gets enough traffic, why no sales?

9 8 years ago

I've read a popular ebook that teaches the reader to make money online. The method involves making lots of websites composed of 5 pages max. Each website would target a specific niche and would sell a specific product or...

  • limberg
    limberg Level 1
  • 12 9 years ago

    I am so happy that I am now at Level 3. Looking forward to level up this year...! I know that I have to work hard for this, but I am sure I can reach

  • CCCA
    CCCA Level 1
  • 23 11 years ago

    If you haven't realized it already, you're going to have to have a dedicated web development environment if you hope to grow into a top-flight coding freelancer. A mandatory practice is to employ a local machine web se...

  • Promodrone
    Promodrone Level 1
  • 4 11 years ago

    What is the worst part of your job as a freelancer? I don't like dealing with irritable customers who demand so much for next to no money. They are already paying so little yet want so much.

  • WynDavies
    WynDavies Level 1
  • 33 11 years ago

    I've noticed how some freelancers work too hard, even 12 hours a day. You would not work so many hours a day at a regular job. Is the income of a freelance day (12 hours or more) really commensurate with what a 'job' w...

  • Justin
    Justin Level 1
  • 27 12 years ago

    This thread for all our Clerk Members to share their YouTube Videos. Reply Embedding your YouTube Video(s), and provide some Information on what it is about. This thread is Not for sharing Channels, do that Here!

  • Sean101
    Sean101 Level 1
  • 2 12 years ago

    Just out of curiosity - How are you guys Marketing your Youtube / Vimeo videos with SEO? Do you think it is beneficial to keep your 'about' section of any particular video, short & to the point, utilizing on tier 1 a...

  • tacitinc
    tacitinc Level X3
  • 2 13 years ago

    Hey guys! This is the main thread for the Tutorials section. It will contain a list of all the tutorials to date, all updates that you might want to know about, and much more. I'm Kutzki, and I run the Tutorials sectio...

  • kutzki
    kutzki Level 1
  • 21 14 years ago
    Order Now
    Process Time: 0.079347133636475

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='Promodrone' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='Promodrone' AND status='1'

    /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

    SELECT * FROM answers WHERE userid=2878371SELECT distinct quesid FROM answers WHERE userid=287837

    /opt/clerks-staging/docroot/faq.php 258 () ()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (10341,12103,12105,12719,12949,13354,24333,16447,15176,26666) LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (10341,12103,12105,12719,12949,13354,24333,16447,15176,26666) LIMIT 1

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (10341,12103,12105,12719,12949,13354,24333,16447,15176,26666) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT 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 A.quesid IN (10341,12103,12105,12719,12949,13354,24333,16447,15176,26666) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    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()

    SELECT * FROM seoclerks.members WHERE USERID='713291'1SELECT profilepicture FROM seoclerks.members WHERE USERID='713291'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='583337'1SELECT profilepicture FROM seoclerks.members WHERE USERID='583337'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='116683'1SELECT profilepicture FROM seoclerks.members WHERE USERID='116683'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='287837'1SELECT profilepicture FROM seoclerks.members WHERE USERID='287837'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='290314'1SELECT profilepicture FROM seoclerks.members WHERE USERID='290314'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='21811'1SELECT profilepicture FROM seoclerks.members WHERE USERID='21811'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='1856'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1856'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='7465'1SELECT profilepicture FROM seoclerks.members WHERE USERID='7465'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='4022'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4022'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    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.4176051SELECT 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 (22) AND gtags like'%googleranking%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4176050.417605
    0.2700591SELECT 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 (47) AND gtags like'%Pa%' AND type !=99 0.2700590.270059
    0.1638771SELECT 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 '%1-2days%' OR A.skills LIKE '%1-2days%') ORDER BY A.lastgigedit desc LIMIT 0,400.1638770.163877