| 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='5898' | 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='5898'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='13366' | 1 | SELECT * FROM seoclerks.members WHERE USERID='13366'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=13366 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=13366
| /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=5898 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=5898
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='5898' 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='5898' 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=27194 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=27194
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='5898' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='5898'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='5898' AND status='1' AND (question like '%After making posts answering FAQ\'s user level increases automatically ??%' OR question like '%After%' OR question like '%making%' OR question like '%posts%' OR question like '%answering%' OR question like '%FAQ\'s%' OR question like '%user%' OR question like '%level%' OR question like '%increases%' OR question like '%automatically%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='5898' AND status='1'
AND (question like '%After making posts answering FAQ\'s user level increases automatically ??%' OR question like '%After%' OR question like '%making%' OR question like '%posts%' OR question like '%answering%' OR question like '%FAQ\'s%' OR question like '%user%' OR question like '%level%' OR question like '%increases%' OR question like '%automatically%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='2537' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2537' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='2637' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2637' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='184' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='184' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='337' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='337' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='2513' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2513' 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=5898%' 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=5898%'
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='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.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()
|
hitmeasap
You can find all the information you need about user levels here:
https://www.seoclerks.com/userlevels/
Level 2 Requirements:
Completed 10 Orders on time
Have a 90% rating or higher
Answered or asked 20 SEO Questions in the FAQ
Have no Infractions (follow the rules)
Login Often (once per 14 days)
Account is at least 7 days
Completed 1 Payment Withdrawal that is 20 days old
First Completed Sale is at least 30 days old
Level 3 Requirements:
Completed 25 Orders on time
Have a 90% rating or higher
Answered or asked 50 SEO Questions in the FAQ
Have no Infractions (follow the rules)
Login Very Often (once per 7 days)
First Completed Sale is at least 60 days old
Upgrades to user levels are automatic.
Please wait at least 20 minutes before entering a ticket about user level promotions if you have not been promoted yet.
Best regards,
hitmeasap Hi there, You can find all the information you need about user levels here: https://www.seoclerks.com/userlevels/ Level 2 Requirements: Completed 10 Orders on time Have a 90% rating or higher Answered or asked 20 SEO Questions in the FAQ Have no Infractions (follow the rules) Login Often (once per 14 days) Account is at least 7 days Completed 1 Payment Withdrawal that is 20 days old First Completed Sale is at least 30 days old Level 3 Requirements: Completed 25 Orders on time Have a 90% rating or higher Answered or asked 50 SEO Questions in the FAQ Have no Infractions (follow the rules) Login Very Often (once per 7 days) First Completed Sale is at least 60 days old Upgrades to user levels are automatic. Please wait at least 20 minutes before entering a ticket about user level promotions if you have not been promoted yet. Best regards, hitmeasap
Are you sure you want to delete this post?