Authoranutosh

Authoranutosh has no services

Need Indian Content Writers - Read full before biddi... Max $100

Hi, We are looking to start a new article writing service and we are hiring...

Authoranutosh Level 1

Studenta Content Financia

Indian Content Writers needed - Read full before bid... Max $10

We are starting a new writing service and hiring freelance writers for it. ...

Authoranutosh Level 1

Studenta

Need Indian Content writers for a new content writin... Max $10

I am looking to start a new content writing service and I am looking for pr...

Authoranutosh Level 1

Studenta Contentw

Buyer Reviews

Seller Reviews

Recommendations

Statuses

Details

Response Time	N/A
Total Ratings	0
Last Seen	1896 days ago

More Info

Responses	0
Discussions	0
Verified User	Yes
Country	IN
RSS	RSS feed

Order Now

Process Time: 0.036006927490234

Possible Duplicate queries found!

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.395301	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (73) AND gtags like'%Laravel7%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.395301	0.395301
0.235012	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (73) AND gtags like'%Laravel7%' AND type !=99	0.235012	0.235012
0.153137	1	SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Simple%' OR A.skills LIKE '%Simple%') ORDER BY A.lastgigedit desc LIMIT 0,40	0.153137	0.153137
0.131812	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Simple%' OR A.skills LIKE '%Simple%')	0.131812	0.131812
0.110902	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Objective%' OR A.skills LIKE '%Objective%')	0.110902	0.110902

SEOClerks

Authoranutosh has no services

Need Indian Content Writers - Read full before biddi... Max $100

Indian Content Writers needed - Read full before bid... Max $10

Need Indian Content writers for a new content writin... Max $10

Buyer Reviews

Recommendations

Statuses

Featured Seller

Invalid SQL

Expensive SQL

Suspicious SQL

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 seoclerks.members WHERE username='Authoranutosh' AND status='1'	1	SELECT * FROM seoclerks.members WHERE username='Authoranutosh' AND status='1'	/opt/clerks-staging/docroot/user.php 54 () ()
SELECT * FROM seoclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM seoclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM seoclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
UPDATE seoclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	1	UPDATE seoclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	1	UPDATE codeclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	1	UPDATE listingdock.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	1	UPDATE pixelclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	1	UPDATE wordclerks.members SET profile_data='{\"userLevelUpdated\":1609900180,\"userTypeUpdated\":1772571902,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='397139'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
SELECT * FROM seoclerks.members WHERE USERID='397139'	1	SELECT lastlogin FROM seoclerks.members WHERE USERID='397139'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays()
SELECT * FROM posts WHERE USERID=397139	1	SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=397139	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()
SELECT * FROM follow F, members M WHERE F.FOLLOWING=397139 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4	1	SELECT F.USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.FOLLOWING=397139 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
SELECT * FROM follow F, members M WHERE F.USERID=397139 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4	1	SELECT F.FOLLOWING AS USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.USERID=397139 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
SELECT * FROM follow WHERE FOLLOWING=397139	1	SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=397139	/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
SELECT * FROM follow WHERE USERID=397139	1	SELECT COUNT(FID) AS total FROM follow WHERE USERID=397139	/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99	1	SELECT count(A.PID) AS total FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, C.profilepicture FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?	1	SELECT count(A.wantid) AS total FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wantbids WHERE active=1 AND wantid='38836'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38836'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM categories_wanttotrade WHERE seo='Article-Writing'	1	SELECT name FROM categories_wanttotrade WHERE seo='Article-Writing'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
SELECT * FROM wantbids WHERE active=1 AND wantid='38807'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38807'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wantbids WHERE active=1 AND wantid='38791'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38791'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC	1	SELECT count(A.tradeid) AS total FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='397139' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1	1	SELECT time FROM inbox2 WHERE MSGFROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1	/opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()
SELECT * FROM seoclerks.ratings WHERE USERID='397139' AND PID != 0	1	SELECT good, bad FROM seoclerks.ratings WHERE USERID='397139' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM codeclerks.ratings WHERE USERID='397139' AND PID != 0	1	SELECT good, bad FROM codeclerks.ratings WHERE USERID='397139' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM listingdock.ratings WHERE USERID='397139' AND PID != 0	1	SELECT good, bad FROM listingdock.ratings WHERE USERID='397139' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM pixelclerks.ratings WHERE USERID='397139' AND PID != 0	1	SELECT good, bad FROM pixelclerks.ratings WHERE USERID='397139' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM wordclerks.ratings WHERE USERID='397139' AND PID != 0	1	SELECT good, bad FROM wordclerks.ratings WHERE USERID='397139' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
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()