| 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='26659' | 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='26659'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='19821' | 1 | SELECT * FROM seoclerks.members WHERE USERID='19821'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=19821 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821
| /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=26659 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=26659
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='26659' 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='26659' 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=189716 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=189716
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='26659' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='26659'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='26659' AND status='1' AND (question like '%Think customer watch sales increase%' OR question like '%Think%' OR question like '%customer%' OR question like '%watch%' OR question like '%sales%' OR question like '%increase%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='26659' AND status='1'
AND (question like '%Think customer watch sales increase%' OR question like '%Think%' OR question like '%customer%' OR question like '%watch%' OR question like '%sales%' OR question like '%increase%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='2921' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2921' 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='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1895' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1895' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' 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=26659%' 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=26659%'
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='868176.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='868176.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()
|
Shivayasea
You are absolutely correct and I completely agree with your articles. I love your article.
But sometimes we need to think opposite on behalf of the customer for rewarding the best professionalism and acknowledge the values of a seller. If a seller project & products are very good and having the world-class superior best quality in it. Will, you going to reward the seller or buyer? Just you need to think of it again.
It is I, you & we can make a difference between customer to sales. If a customer wants the best, genuine, world-class superior projects or products to buy, a buyer has to spend more on legit things so when after delivery or on hands a buyer will see the results, definitely that buyer will be very happy and recommended to all other nations or other buyers thus seller will be pleased, happy and buyer will feel very proud of having such a good seller with him or her vice versa.
This is really hard to understand & truth behind everything but as you know truth is always truth. Where the buyer and seller equally important for any business.
When all seller will understand this strictness universal truth then the buyer will definitely be very happy with the seller. I guarantee 100%.
Rest it depends on various factors; still.
oh, I just forget to type about marketing, I am requesting to make an article about how to develop marketing skills on seoclerks.com
This is my opinion!
------------------------
Thank you
Kind regards
Cheers
Shivayasea Respected Sir, You are absolutely correct and I completely agree with your articles. I love your article. But sometimes we need to think opposite on behalf of the customer for rewarding the best professionalism and acknowledge the values of a seller. If a seller project & products are very good and having the world-class superior best quality in it. Will, you going to reward the seller or buyer? Just you need to think of it again. It is I, you & we can make a difference between customer to sales. If a customer wants the best, genuine, world-class superior projects or products to buy, a buyer has to spend more on legit things so when after delivery or on hands a buyer will see the results, definitely that buyer will be very happy and recommended to all other nations or other buyers thus seller will be pleased, happy and buyer will feel very proud of having such a good seller with him or her vice versa. This is really hard to understand & truth behind everything but as you know truth is always truth. Where the buyer and seller equally important for any business. When all seller will understand this strictness universal truth then the buyer will definitely be very happy with the seller. I guarantee 100%. Rest it depends on various factors; still. oh, I just forget to type about marketing, I am requesting to make an article about how to develop marketing skills on seoclerks.com [b]This is my opinion![/b] ------------------------ Thank you Kind regards Cheers Shivayasea
Are you sure you want to delete this post?