Discussions about Intro

Why can't I sell my freelance services on SEOClerks? Answered

My Name is Joyson Simon. I Am a Professional Motion Graphic And Vfx artist From India I posted a service two days ago for intro animations. I have previous experience selling on other sites and want to try it out h...

DigiLab Level 1

14 9 years ago

What is the best length of a introduction video? Answered

I've previously made a video for a service of mine. The video is 1 minute and 22 seconds and I believe it includes everything it should. However, I'm curious to know what others think? Sure, the length would obviou...

hitmeasap Level X⁵

10 9 years ago

How to promote my service in SEOCLERCK to get good orders Answered

Hi, Can any one help me to get good orders in seoclerck . I was in here from last 2 years but not satisfied with the order that am getting please help me with this guys . Thanks.

seo1011 Level 1

10 10 years ago

Where to get free royality free music for animation video? Answered

I make animated video for logo intro videos and I am facing problem to get the sound effects and music.

muneebalam Level 1

4 13 years ago

Is my service really that bad Answered

Hi, I saw people selling video intro's some for $6 and some for $7. I'm selling it for $1 but I didn't get a single sale. I mean I'm selling it really cheap! Here's the link: http://www.seoclerks.com/video/22077/make...

burhanhaq Level 1

8 14 years ago

Load	Count	SQL	Max	Min
0.234204	4	SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600	0.062908	0.053212
0.113911	2	SELECT `value`, `last_checked` FROM query_cache WHERE query= ? LIMIT 1	0.059295	0.054616

Avg Time	Count	SQL	Max	Min
8.494477	1	SELECT 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'%onsite%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	8.494477	8.494477
0.512086	1	SELECT 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 (87) AND gtags like'%Best%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.512086	0.512086
0.457091	1	SELECT 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'%WhiteHatMethod%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.457091	0.457091
0.266010	1	SELECT 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 (22) AND gtags like'%WhiteHatMethod%' AND type !=99	0.266010	0.266010
0.105322	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Backlinkks%') ORDER BY total_recommendations desc LIMIT 0,40	0.105322	0.105322
0.058551	4	SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600	0.062908	0.053212
0.056956	2	SELECT `value`, `last_checked` FROM query_cache WHERE query= ? LIMIT 1	0.059295	0.054616
0.056222	1	SELECT 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 (68,69) AND gtags like'%A%' AND type !=99	0.056222	0.056222
0.052859	1	SELECT 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 (68,69) AND gtags like'%A%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.052859	0.052859

SEOClerks

Discussions about Intro

Why can't I sell my freelance services on SEOClerks? Answered

What is the best length of a introduction video? Answered

How to promote my service in SEOCLERCK to get good orders Answered

Where to get free royality free music for animation video? Answered

Is my service really that bad Answered

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
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.tags LIKE '% Intro %' OR A.tags LIKE 'Intro %' OR A.tags LIKE '% Intro' OR A.tags='Intro') LIMIT 1	1	SELECT 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.tags LIKE '% Intro %' OR A.tags LIKE 'Intro %' OR A.tags LIKE '% Intro' OR A.tags='Intro') 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.tags LIKE '% Intro %' OR A.tags LIKE 'Intro %' OR A.tags LIKE '% Intro' OR A.tags='Intro') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	1	SELECT 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.tags LIKE '% Intro %' OR A.tags LIKE 'Intro %' OR A.tags LIKE '% Intro' OR A.tags='Intro') 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'	1	SELECT 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'	1	SELECT 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	1	SELECT 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 categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='611395'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='611395'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='6160'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='6160'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='276321'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='276321'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='15260'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='15260'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='10514'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='10514'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()