| 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='3210' | 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='3210'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='1748' | 1 | SELECT * FROM seoclerks.members WHERE USERID='1748'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=1748 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1748
| /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=3210 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=3210
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='3210' 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='3210' 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=39897 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=39897
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='3210' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='3210'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='3210' AND status='1' AND (question like '%How I change feedback?%' OR question like '%change%' OR question like '%feedback?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='3210' AND status='1'
AND (question like '%How I change feedback?%' OR question like '%change%' OR question like '%feedback?%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' 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='1364' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1677' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1677' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='3764' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' 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=3210%' 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=3210%'
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='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.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()
|
Beverly
Buyers have up to 20 days to change a rating for a service, after the 20 days is exceeded, you can no longer alter the service rating.
Please follow the steps as described below to change a review/feedback and/or rating for a service:
1. Make sure you're logged into the SEOClerk marketplace, you can login here:
https://www.seoclerk.com/login
2. Hover over the "BUYER" tab on the navigation, then hover over the "Shopping" label find "Purchases" - click on the "Purchases" link.
3. You'll be taken to your previous orders, find the ORDER ID # - click it.
4. Once you click the ORDER ID # you'll be taken to your order tracking page. Find the title of the service, which is located on the top of the page, it's the largest text on the page - click the service title.
5. Scroll down until you find your rating under the "User Ratings" header, you may need to load more ratings as some services get many ratings per day.
6. Find "Edit", this is directly above the timestamp and to the right of the review/feedback, click on "Edit".
7. A popup window will appear, which will display the current review/feedback along with the rating, adjust the rating for the service and/or review/feedback.
8. Click on the "Save Edit" button (this button is blue and to the right of the close button on the popup window)
Once you have saved the edited rating, the service's ratings will update within 20 minutes - as we use a cache system. If the service has not updated within an hour or two please contact us.
If you need any further assistance in changing a review/feedback and/or rating for a service please do not hesitate to reply back to this ticket. If the ticket is closed, once you reply back, the ticket will automatically reopen for you.
If you are unable to change feedback, you can request assistance from staff via the support desk. Here is the official answer on changing your buyer feedback. Buyers have up to 20 days to change a rating for a service, after the 20 days is exceeded, you can no longer alter the service rating. Please follow the steps as described below to change a review/feedback and/or rating for a service: 1. Make sure you're logged into the SEOClerk marketplace, you can login here: https://www.seoclerk.com/login 2. Hover over the "BUYER" tab on the navigation, then hover over the "Shopping" label find "Purchases" - click on the "Purchases" link. 3. You'll be taken to your previous orders, find the ORDER ID # - click it. 4. Once you click the ORDER ID # you'll be taken to your order tracking page. Find the title of the service, which is located on the top of the page, it's the largest text on the page - click the service title. 5. Scroll down until you find your rating under the "User Ratings" header, you may need to load more ratings as some services get many ratings per day. 6. Find "Edit", this is directly above the timestamp and to the right of the review/feedback, click on "Edit". 7. A popup window will appear, which will display the current review/feedback along with the rating, adjust the rating for the service and/or review/feedback. 8. Click on the "Save Edit" button (this button is blue and to the right of the close button on the popup window) Once you have saved the edited rating, the service's ratings will update within 20 minutes - as we use a cache system. If the service has not updated within an hour or two please contact us. If you need any further assistance in changing a review/feedback and/or rating for a service please do not hesitate to reply back to this ticket. If the ticket is closed, once you reply back, the ticket will automatically reopen for you. If you are unable to change feedback, you can request assistance from staff via the support desk.
Are you sure you want to delete this post?