| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400
| /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
|
| 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='29820' | 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='29820'
| /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=29820 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=29820
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29820' 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='29820' 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=189536 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=189536
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29820' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29820'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29820' AND status='1' AND (question like '%How website business attract investor%' OR question like '%website%' OR question like '%business%' OR question like '%attract%' OR question like '%investor%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29820' AND status='1'
AND (question like '%How website business attract investor%' OR question like '%website%' OR question like '%business%' OR question like '%attract%' OR question like '%investor%')
-- 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='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='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='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='231' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='231' 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=29820%' 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=29820%'
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
I like your article in such a way that I would like to have this article on my post.
Did you know Sir, for any website or business, if you would like to grow faster, you must have enough funds to force a visitor first by organic or by advertising method?
On seoclerks I don't even understand why buyers or sellers buy and sell their service at a very cheap price.
I would like to tell my experience on SEO clerks.
A buyer messages me can you provide traffic from google, yahoo, bing and I need 20,000 visitors per day for 30 days including conversion or results. Can you?
My reply:- Sorry I cannot but wait I can give you daily 10-15 visitors from google, yahoo, and bing for 30 days and it will have cost around $150 - $ $200 or maybe more and I said buyer please upload your website for investigation and I came to know that website has all Amazon and Aliexpress products on it.
Then I said to the buyer; you will get only 10 visitors per day from all leading search engines for 30 days.
Then that buyer said to me.
Enough!
I don't want to buy from you when others seller is providing $1 = 10,000 visitor for 30 days.
I said to the buyer "they are all talented sellers and I am not talented.
What is the moral of the converssation>?
If I say to the buyer you have a shopping site and it cost per click from US, Canada $29 per click from Google. then that buyer might be thinking I am selling my service for profits. ( I message too )
Who is going to believe PPC costs me $19-$29 per clicks for a simple shopping site.?
Next, I said to the buyer...
I text to the buyer and said if Google can provide $1 = 10,000 Visitors to your Shopping site definitely I will give you FREE Traffic or I will charge $1 for 10,000 ( Just Ask Google or Facebook ) Nice! I like your article in such a way that I would like to have this article on my post. Did you know Sir, for any website or business, if you would like to grow faster, you must have enough funds to force a visitor first by organic or by advertising method? On seoclerks I don't even understand why buyers or sellers buy and sell their service at a very cheap price. I would like to tell my experience on SEO clerks. A buyer messages me can you provide traffic from google, yahoo, bing and I need 20,000 visitors per day for 30 days including conversion or results. Can you? My reply:- Sorry I cannot but wait I can give you daily 10-15 visitors from google, yahoo, and bing for 30 days and it will have cost around $150 - $ $200 or maybe more and I said buyer please upload your website for investigation and I came to know that website has all Amazon and Aliexpress products on it. Then I said to the buyer; you will get only 10 visitors per day from all leading search engines for 30 days. Then that buyer said to me. Enough! I don't want to buy from you when others seller is providing $1 = 10,000 visitor for 30 days. I said to the buyer "they are all talented sellers and I am not talented. What is the moral of the converssation>? If I say to the buyer you have a shopping site and it cost per click from US, Canada $29 per click from Google. then that buyer might be thinking I am selling my service for profits. ( I message too ) Who is going to believe PPC costs me $19-$29 per clicks for a simple shopping site.? Next, I said to the buyer... I text to the buyer and said if Google can provide $1 = 10,000 Visitors to your Shopping site definitely I will give you FREE Traffic or I will charge $1 for 10,000 ( Just Ask Google or Facebook )
Are you sure you want to delete this post?