| 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='21581' | 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='21581'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='565586' | 1 | SELECT * FROM seoclerks.members WHERE USERID='565586'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=565586 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=565586
| /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=21581 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=21581
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21581' 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='21581' 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=114942 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=114942
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='21581' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='21581'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='21581' AND status='1' AND (question like '% payment hold time period sale withdrawal%' OR question like '%payment%' OR question like '%hold%' OR question like '%time%' OR question like '%period%' OR question like '%sale%' OR question like '%withdrawal%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='21581' AND status='1'
AND (question like '% payment hold time period sale withdrawal%' OR question like '%payment%' OR question like '%hold%' OR question like '%time%' OR question like '%period%' OR question like '%sale%' OR question like '%withdrawal%')
-- 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='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| 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='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' 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=21581%' 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=21581%'
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 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()
|
idealmike
However, even if you do do all that, there is no guarantee your buyer will positively rate and complete your delivered work for you. Some buyers just don't leave feedback for their delivered orders no matter how good a job you do for them.
This could be for a number of reasons;
So that is why you should do all the above. You can kindly remind people to leave their feedback for your service. But you should never bully or bolster your buyers into doing so. Doing that will likely result in a negative feedback being left you.
I would rather have no feedback left and wait the 5 days before I can get the money than receive a negative rating.
And I'm sure many others would agree with that.
Hope this helps!
Mike. Hi Zeee, after you deliver the order, it will be automatically completed in 5 days time. You will then have to wait another 24 hours for the funds to clear before they are available for withdraw. However, if your buyer positively rates your delivered order, it will be completed much faster and your funds will then be available for withdraw after only 24 hours. That is why you should make sure to; [list=square] [*]Deliver your work exactly as advertised.[/*][*]Deliver your work within/before the deadline.[/*][*]Ensure that the buyer is happy with your work.[/*][*]Encourage positive feedback by making sure they are happy.[/*][*]Going the extra mile to provide them with an excellent service.[/*][/list] However, even if you do do all that, there is no guarantee your buyer will positively rate and complete your delivered work for you. Some buyers just don't leave feedback for their delivered orders no matter how good a job you do for them. This could be for a number of reasons; [list=disc] [*]They don't understand how the site works and don't know they need to leave feedback for it.[/*][*]They don't want to leave feedback because they don't want their name showing up in your service.[/*][*]They know how the system works and want you to wait the extra 5 days before you can get the money.[/*][/list] So that is why you should do all the above. You can kindly remind people to leave their feedback for your service. But you should never bully or bolster your buyers into doing so. Doing that will likely result in a negative feedback being left you. I would rather have no feedback left and wait the 5 days before I can get the money than receive a negative rating. And I'm sure many others would agree with that. Hope this helps! Mike.
Are you sure you want to delete this post?