W130SN
Level X5
Write the reason you're deleting this FAQ
There are many services offered on SEOClerks and thankfully not every Seller offers the same service.
I propose a JV Section where Sellers offering complimentary services, can JV to promote additional services that may be useful to the Buyer.
e.g Seller A provides Twitter Followers but recommends an additional service to his Buyer from Seller B who provides Facebook Likes.
Any Affiliate Sale made from this recommendation would result in Seller A receiving an additional 5% paid from Seller B's revenue.
I don't know how workable this would be or if it would be difficult to implement.
Just a suggestion. What do you think of the idea?
Some sellers do this already by providing their own affiliate link to another seller's service that compliments their own when they deliver work to a buyer.
A cool extension of your JV idea might be to have like-minded sellers group themselves together as a kind of project service provider group.
For example, the "group" could provide an all-inclusive website package to a buyer that includes complete web design, script installation, written content, backlinks and traffic, whereby each seller has one task to do as part of the project.
Another example might be to have a social media group that specializes in followers, likes, etc, from a wide range of social media websites.
The benefit to the buyer would be having a "one stop shop" to complete an entire project, instead of needing to search through 100's of sellers to choose 4-5 doing different things. It's a more streamlined option for larger projects.
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='12261' | 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='12261' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='31594' | 1 | SELECT * FROM seoclerks.members WHERE USERID='31594' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='39' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=31594 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=31594 | /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=12261 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=12261
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12261' 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='12261' 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=57956 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=57956
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57957 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=57957
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12261' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='12261' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='12261' AND status='1' AND (question like '%Joint Venture - JV Section%' OR question like '%Joint%' OR question like '%Venture%' OR question like '%Section%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='12261' AND status='1'
AND (question like '%Joint Venture - JV Section%' OR question like '%Joint%' OR question like '%Venture%' OR question like '%Section%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='10381' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='10381' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='226993' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='226993' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='15054' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='15054' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='29853' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='29853' 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=12261%' 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=12261%'
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='167023.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='167023.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='31594.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='31594.jpg' | /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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
Asmodeus
A cool extension of your JV idea might be to have like-minded sellers group themselves together as a kind of project service provider group.
For example, the "group" could provide an all-inclusive website package to a buyer that includes complete web design, script installation, written content, backlinks and traffic, whereby each seller has one task to do as part of the project.
Another example might be to have a social media group that specializes in followers, likes, etc, from a wide range of social media websites.
The benefit to the buyer would be having a "one stop shop" to complete an entire project, instead of needing to search through 100's of sellers to choose 4-5 doing different things. It's a more streamlined option for larger projects. Some sellers do this already by providing their own affiliate link to another seller's service that compliments their own when they deliver work to a buyer. A cool extension of your JV idea might be to have like-minded sellers group themselves together as a kind of project service provider group. For example, the "group" could provide an all-inclusive website package to a buyer that includes complete web design, script installation, written content, backlinks and traffic, whereby each seller has one task to do as part of the project. Another example might be to have a social media group that specializes in followers, likes, etc, from a wide range of social media websites. The benefit to the buyer would be having a "one stop shop" to complete an entire project, instead of needing to search through 100's of sellers to choose 4-5 doing different things. It's a more streamlined option for larger projects.
Are you sure you want to delete this post?