Discussions about Reports

The importance of reports in SEO Answered

Over the years, we've talked a lot about SEO and how to implement SEO techniques that work and have a direct impact on your website or for your client's websites. We also discussed on how to increase the number of client...

Cristian Level X³

10 9 years ago

Audio Books. - One of the best products you can create? Answered

Freelancers, We live in a time where it's almost natural for us all to write and sell ebooks, guides and reports. Hundreds of people are doing it everyday and even though just a handful of people succeed, there's always...

hitmeasap Level X⁵

7 9 years ago

Feature Request: Sales reports daily/weekly/monthly etc Answered

Hello. I would like to suggest a feature for being able to see sales reports to see how much money you've made in sales for the week, or month or year. I know we can see how many sales we've had in our My Balance page. A...

idealmike Level X³

9 10 years ago

Why doesn't Payza have monthly statements and reports? Answered

I can't find any kind of reports from Payza via the login/dashboard. I've looked everywhere. PayPal offers a monthly statement report that summarizes everything you've sold, sent, withdrawn, fees, etc. (amongst other rep...

robertman11 Level 2

7 10 years ago

What is the best automated SEO reports tool? Answered

generates most detailed seo reports for websites and it has a free version for registered users which means that you can use 10 times a day this tool for free.

shaira Level 1

1 13 years ago

Avg Time	Count	SQL	Max	Min
0.450328	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 (80,51) AND gtags like'%exceltopdf%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.450328	0.450328
0.308085	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 (88) AND gtags like'%Editing%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.308085	0.308085
0.115603	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 '% own %' OR A.tags LIKE 'own %' OR A.tags LIKE '% own' OR A.tags='own') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	0.115603	0.115603
0.109858	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 '% paying %' OR A.tags LIKE 'paying %' OR A.tags LIKE '% paying' OR A.tags='paying') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	0.109858	0.109858
0.103098	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 '% Ab %' OR A.tags LIKE 'Ab %' OR A.tags LIKE '% Ab' OR A.tags='Ab') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	0.103098	0.103098
0.076833	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 '% Ab %' OR A.tags LIKE 'Ab %' OR A.tags LIKE '% Ab' OR A.tags='Ab') LIMIT 1	0.076833	0.076833
0.076374	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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') LIMIT 1	0.076374	0.076374
0.074914	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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	0.074914	0.074914
0.067383	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 '% own %' OR A.tags LIKE 'own %' OR A.tags LIKE '% own' OR A.tags='own') LIMIT 1	0.067383	0.067383
0.065757	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 '% paying %' OR A.tags LIKE 'paying %' OR A.tags LIKE '% paying' OR A.tags='paying') LIMIT 1	0.065757	0.065757

SEOClerks

Discussions about Reports

The importance of reports in SEO Answered

Audio Books. - One of the best products you can create? Answered

Feature Request: Sales reports daily/weekly/monthly etc Answered

Why doesn't Payza have monthly statements and reports? Answered

What is the best automated SEO reports tool? 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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') 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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') 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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') 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 '% Reports %' OR A.tags LIKE 'Reports %' OR A.tags LIKE '% Reports' OR A.tags='Reports') 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='134'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='134'	/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='272'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='272'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='9'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='26480'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='26480'	/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()