Answers from user Gemison Page 2

When you know you can't complete a job Answered

What will you do when you have worked a significant amount of time on a project and come upon an insurmountable situation where you know you won't be able to complete the job or provide the results the client is looking ...

Caitlin Level 1

18 12 years ago

Need help. Feeling overwhelmed by SPAM Answered

My Adsense email is on AOL mail, dating back to the time when I used AOL mail exclusively. For some reason, the email address is spammed with about 6000 emails from sites I don't visit anymore. I'm not sure where to be...

Beverly Level X³

5 13 years ago

What causes a high bounce rate? Answered

What are some of the factors which could cause a website to have high bounce rate, such as where a visitor clicks through from search engine listing and then clicks back quickly. What are some reasons that happens?

Beverly Level X³

37 13 years ago

How long did it take to get approved for Adsense? Answered

How long did it take your site to get approved for Adsense?

Beverly Level X³

11 13 years ago

SEOClerks Affiliate Store Answered

-SEOClerks affiliate store for $25!- SEOClerks recently added an api feature to their website, with this api feature I was able to create the first ever SEOClerks based affiliate store. What does it do and why you N...

ShadyX Level 4

82 13 years ago

Should be less awaiting delay after order delivery Answered

hey guys, first of all i want to thank Admin and Mods here who always gave me good response when i ever need help from them . i am really enjoying working on this website and enjoying pretty money coming to my account ;)...

moneygoddy Level 1

6 13 years ago

Avg Time	Count	SQL	Max	Min
0.389212	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 (90) AND gtags like'%face%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.389212	0.389212

SEOClerks

Answers from user Gemison Page 2

When you know you can't complete a job Answered

Need help. Feeling overwhelmed by SPAM Answered

What causes a high bounce rate? Answered

How long did it take to get approved for Adsense? Answered

SEOClerks Affiliate Store Answered

Should be less awaiting delay after order delivery Answered

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT 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 seoclerks.members WHERE username='Gemison' AND status='1'	1	SELECT USERID FROM seoclerks.members WHERE username='Gemison' AND status='1'	/opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
SELECT * FROM answers WHERE userid=180358	1	SELECT distinct quesid FROM answers WHERE userid=180358	/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 (11072,11073,11074,11075,11080,11384,11399,11408,11410,12863,12864,12865,12867,12871,12890,12893,12900,12930,12978,12997,13126,13130,13135,13142,13280,13281,13283,13285,13290,13296,13303,13475,13476,13483,13527,13822,13824,13825,13875,13878,13902,14162,14835,17168,17188,17322,17331,17398) 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.quesid IN (11072,11073,11074,11075,11080,11384,11399,11408,11410,12863,12864,12865,12867,12871,12890,12893,12900,12930,12978,12997,13126,13130,13135,13142,13280,13281,13283,13285,13290,13296,13303,13475,13476,13483,13527,13822,13824,13825,13875,13878,13902,14162,14835,17168,17188,17322,17331,17398) 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 (11072,11073,11074,11075,11080,11384,11399,11408,11410,12863,12864,12865,12867,12871,12890,12893,12900,12930,12978,12997,13126,13130,13135,13142,13280,13281,13283,13285,13290,13296,13303,13475,13476,13483,13527,13822,13824,13825,13875,13878,13902,14162,14835,17168,17188,17322,17331,17398) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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.quesid IN (11072,11073,11074,11075,11080,11384,11399,11408,11410,12863,12864,12865,12867,12871,12890,12893,12900,12930,12978,12997,13126,13130,13135,13142,13280,13281,13283,13285,13290,13296,13303,13475,13476,13483,13527,13822,13824,13825,13875,13878,13902,14162,14835,17168,17188,17322,17331,17398) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='21613'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='21613'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='147'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='147'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='792'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='792'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='155'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='155'	/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()