ASRIZVI
Level 1
Write the reason you're deleting this FAQ
how i can work on seoclerk site SEO marketing
tell me about how i could get access in affiliate marketing.
Are you sure you want to delete this post?
I think the guys have covered this well, but yeah your question really isn't clear at all. Maybe next time try and explain more clearly :)
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='19470' | 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='19470' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='506740' | 1 | SELECT * FROM seoclerks.members WHERE USERID='506740' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='35' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='35' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=506740 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=506740 | /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=19470 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=19470
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19470' 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='19470' 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=106713 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=106713
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=106721 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=106721
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=106788 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=106788
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19470' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19470' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='19470' AND status='1' AND (question like '%Tell Tips monsterbacklink work.%' OR question like '%Tell%' OR question like '%Tips%' OR question like '%monsterbacklink%' OR question like '%work.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19470' AND status='1'
AND (question like '%Tell Tips monsterbacklink work.%' OR question like '%Tell%' OR question like '%Tips%' OR question like '%monsterbacklink%' OR question like '%work.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='3524' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3524' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1177' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1177' 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='4136' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4136' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=19470%' 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=19470%'
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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.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 |
| 0.065968 | 1 | SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%revision%') | 0.065968 | 0.065968 |
idealmike
I presume you're asking "How can I do SEO Marketing work on SEOClerks right? Well let's say you're asking that. In which case, the same way as you do other things. You need to put a service up that sells that kind of thing. I see you already have some services up on here so you know the ropes as far as doing that is concerned. So create a new service that offers SEO marketing. List out all the things that you'll actually do in that service. What it is people will be getting when they order along with the benefits of your service.
Well, affiliate marketing isn't some club you can join so you can't get access to it from that perspective. Rather, affiliate marketing is something you can do. As an affiliate. By marketing peoples products or services. That just means advertising them in some way. The way it works is simple. You find a good product or service that is high in demand. Then you market/promote/advertise that product/service, as an affiliate for them. If you're talking about being an affiliate for SEOClerks then you already are. Just visit your Affiliate settings page. And there you will find your affiliate link and instruction on how to make any service URL on here into an affiliate URL. You can then promote/share/advertise and market those links in many different ways. The more you do, the more affiliates you get, the more you earn.
That's pretty much everything there is to know in a nut shell.
But if you have any other questions let us know and be clear and specific about them so we can help you.
Hope this helps!
Mike. Hi mate. Your questions aren't really clear and are a bit vague. It's not really clear what it is you're asking for exactly. I appreciate you're posting for a bump but do try to be more clear in what it is you're asking. In your title you ask about [b]seoclerk work[/b]. But in your questions you're asking about [b]SEOClerks[/b]. Regardless, I'll try to answer them based on what I think you're asking. [quote][b]how i can work on seoclerk site SEO marketing[/b][/quote] I presume you're asking "[b]How can I do SEO Marketing work on SEOClerks[/b] right? Well let's say you're asking that. In which case, the same way as you do other things. You need to put a service up that sells that kind of thing. I see you already have some services up on here so you know the ropes as far as doing that is concerned. So create a new service that offers SEO marketing. List out all the things that you'll actually do in that service. What it is people will be getting when they order along with the benefits of your service. [quote][b]tell me about how i could get access in affiliate marketing.[/b][/quote] Well, affiliate marketing isn't some club you can join so you can't get access to it from that perspective. Rather, affiliate marketing is something you can do. As an affiliate. By marketing peoples products or services. That just means advertising them in some way. The way it works is simple. You find a good product or service that is high in demand. Then you market/promote/advertise that product/service, as an affiliate for them. If you're talking about being an affiliate for SEOClerks then you already are. Just visit [url=https://www.seoclerks.com/balance/affiliate]your Affiliate settings page[/url]. And there you will find your affiliate link and instruction on how to make any service URL on here into an affiliate URL. You can then promote/share/advertise and market those links in many different ways. The more you do, the more affiliates you get, the more you earn. That's pretty much everything there is to know in a nut shell. But if you have any other questions let us know and be clear and specific about them so we can help you. :) Hope this helps! Mike.
Are you sure you want to delete this post?