| 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 `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='29378' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='29378'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='299892' | 1 | SELECT * FROM seoclerks.members WHERE USERID='299892'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=299892 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=299892
| /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
|
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=29378 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=29378
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29378' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='29378' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc
| /opt/clerks-staging/docroot/viewfaq.php 1245 () ()
|
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=188776 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=188776
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29378' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29378'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29378' AND status='1' AND (question like '%Why Information Products Great Brand Building%' OR question like '%Information%' OR question like '%Products%' OR question like '%Great%' OR question like '%Brand%' OR question like '%Building%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29378' AND status='1'
AND (question like '%Why Information Products Great Brand Building%' OR question like '%Information%' OR question like '%Products%' OR question like '%Great%' OR question like '%Brand%' OR question like '%Building%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='6070' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6070' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='3080' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3080' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=29378%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=29378%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png'
| /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()
|
TommyCarey
I know a few people who have written ebooks in the past and they've solely used them for promotional material in order to build up their email lists. They work well as freebies and don't pull as much profit as they used to 10+ years ago, but there are still smaller niches that can be tapped into if you're a good writer and can fill a void or fix a problem for the users there.
Bigger sellers will design entire courses locked behind a membership wall that only individuals who pay upfront can access. The people behind the courses will, of course, write up whatever they can, in detail, and give away everything they possibly can in order to get more subscriptions but at the end of the day, your platform is only as successful as the content you're writing or videos you're posting. You can actually get a bad reputation for charging too much for courses that can be learned for free online and not providing your community much value for their hard-earned money. On the other hand, you can get waves of positive reviews coming in and boost your branding much more with these courses if you do them well enough to please everyone for the few dollars a month that they invest
For all of this, you can usually find plenty of people here that can do an excellent job designing your sites, creating images for your ebooks, writing the content for your ebooks, and various other things. The only branding play in your discussion that would need more attention to detail and expensive work is if you went with the paperback book option. It takes a while to get these books published, it's not cheap to have them printed and bound, and it's more expensive if you're only printing up a limited run compared to a batch of 100,000+ books. Your investment is more at risk with this type of branding and advertising than it is with an ebook or online course. Informational products are definitely a top-level play for branding if you plan to do other things alongside it. You can, of course, get 1,000s of orders for your ebook but if someone stops reading then your branding is done for. What you should do is get them to click through to a page where you have a retargeting script specifically for the people who purchased an ebook or ecourse and then show them certain ads that will encourage them to sign up with you or follow you across all your social media platforms. I know a few people who have written ebooks in the past and they've solely used them for promotional material in order to build up their email lists. They work well as freebies and don't pull as much profit as they used to 10+ years ago, but there are still smaller niches that can be tapped into if you're a good writer and can fill a void or fix a problem for the users there. Bigger sellers will design entire courses locked behind a membership wall that only individuals who pay upfront can access. The people behind the courses will, of course, write up whatever they can, in detail, and give away everything they possibly can in order to get more subscriptions but at the end of the day, your platform is only as successful as the content you're writing or videos you're posting. You can actually get a bad reputation for charging too much for courses that can be learned for free online and not providing your community much value for their hard-earned money. On the other hand, you can get waves of positive reviews coming in and boost your branding much more with these courses if you do them well enough to please everyone for the few dollars a month that they invest :D For all of this, you can usually find plenty of people here that can do an excellent job designing your sites, creating images for your ebooks, writing the content for your ebooks, and various other things. The only branding play in your discussion that would need more attention to detail and expensive work is if you went with the paperback book option. It takes a while to get these books published, it's not cheap to have them printed and bound, and it's more expensive if you're only printing up a limited run compared to a batch of 100,000+ books. Your investment is more at risk with this type of branding and advertising than it is with an ebook or online course.
Are you sure you want to delete this post?