Hey Clerks Nation, It's time for a new Fun Friday Raffle. Just reply to this thread your name will be added to a random drawing. It will close on Monday July 28th at 12:00 a.m. EST Good luck to everyone!
Hey Clerks Nation, It's time for a new Fun Friday Raffle. Just reply to this thread your name will be added to a random drawing. It will close on Monday July 21st at 12:00 a.m. EST Good luck to everyone!
Hello Clerks Nation, We are replacing the Fun Friday Contest with a Fun Friday Raffle. All you have to do is reply to this thread and your name will be entered into a random drawing. The raffle will close on Monday at...
Hello Clerks Nation, It's time for the Fun Friday Contest! This contest will be for the user with the most affiliate sales between now and Monday June 30th at 12:00 a.m. EST. You must reply to this thread to enter into...
Hello Clerks Nation, It's time again for the Fun Friday Contest! This weeks contest will be for the user that brings the most affiliate users. To enter into the contest you must reply to this thread. Good luck to e...
Hello Clerks Nation, This weeks contest will be another random drawing. Just reply to the thread and your name will be entered into a random drawing. The contest is simple so don't miss out on the opportunity to win a...
Hey Clerks Nation, Join us in congratulating ericplotz1 for being promoted to level X. Being promoted to level X is no small task and ericplotz1 has been a valuable member of the Clerks Nation and has built a good rep...
Hello Clerks Nation, It's time for the Fun Friday Contest! This contest is a little more involved than usual. To enter into the contest please submit a promotional video about SEOClerks. There are no restrictions on ...
Hello Clerks Nation, It's time again for the Fun Friday Contest. This week the contest will be for the best service description. Submit your service description in the forum to enter the contest. The contestants wil...
Hey Clerks Nation, It's time again for the Fun Friday Contest! This weeks contest will be a random drawing. All you need to do is reply to the forum thread and your name will be put in the random drawing to win a $25...
We are accepting new users (affiliates) to generate and give out free $5 coupons. The coupons are redeemable by any new members of SEOClerks/CodeClerks/ListingDock, typically after they have signed up under you as an aff...
Hey Clerks Nation, It's time again for the Fun Friday Contest. This weeks contest will be for whoever can get the most positive reviews on completed sales. This will include positive reviews for both buyers and seller...
Hey Clerks Nation, It's time again for the Fun Friday Contest. This weeks contest will be for the most sales between now and 12:00 a.m. EST on Monday, March 31st. The seller with the most services sold will receive ...
Hey Clerks Nation, It's time for the Fun Friday Contest. This weeks contest will be for most affiliate sales based on dollar amount, not quantity. To enter the contest, you must reply to this thread and at the closing...
Hey Clerks Nation, It's time again for the Fun Friday contest. This week, when you share our FaceBook post your name will be entered into a drawing to win the $25 coupon. The link to the post you need to share is belo...
Hey Clerks Nation, It's time again for the Fun Friday Contest! This contest is simple. To participate just go to the link below and retweet the SEOClerks post about earning 100% from your own clients. Once you have d...
Hey Clerks Nation, We are in the process of changing and updating the user level requirements. Some users level may change but their are more updates coming in the next 24-48 hours. You can check out SOME of the chang...
Hey Clerks Nation, It's time for the Fun Friday Contest! This week you need to submit a link and Screenshot of the main page of your affiliate website. Submissions will be judged based on appearance and design. The...
What is the best way of getting a lot of orders?
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='musicpromo' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='musicpromo' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| SELECT * FROM answers WHERE userid=42090 | 1 | SELECT distinct quesid FROM answers WHERE userid=42090 | /opt/clerks-staging/docroot/faq.php 258 () () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (3526,10343,10485,10491,10493,10494,10495,10506,10507,10510,10511,10514,10515,10517,10519,10520,10521,10522,10524) LIMIT 1 | 1 | SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (3526,10343,10485,10491,10493,10494,10495,10506,10507,10510,10511,10514,10515,10517,10519,10520,10521,10522,10524) LIMIT 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (3526,10343,10485,10491,10493,10494,10495,10506,10507,10510,10511,10514,10515,10517,10519,10520,10521,10522,10524) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | 1 | SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (3526,10343,10485,10491,10493,10494,10495,10506,10507,10510,10511,10514,10515,10517,10519,10520,10521,10522,10524)
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' | 1 | SELECT count(A.quesid) as total from questions as A
where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM answers as A where A.status='1' | 1 | SELECT count(A.ansid) as total
FROM answers as A where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE (script='/opt/clerks-staging/docroot/faq.php'
OR script='/opt/clerks-staging/docroot/viewfaq.php')
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='42124' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='42124' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='1' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='28163' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='28163' | /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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
