| 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 wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID | 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
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,40 | 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
ORDER BY A.bdays desc
LIMIT 0,40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1639' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1639' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22848' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22848' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='23053' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23053' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='24700' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24700' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1640' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1640' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1840' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1840' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2226' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2226' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='5261' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='5261' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4213' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4213' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4360' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4360' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25429' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25429' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52625' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52625' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2563' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2563' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2660' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2660' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='7438' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='7438' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='16414' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16414' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='19500' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19500' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22366' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22366' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='23362' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23362' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25158' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25158' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='37652' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37652' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='43590' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43590' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='45940' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45940' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='9055' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9055' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='10347' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='10347' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='36434' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36434' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22119' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22119' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25918' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25918' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='15579' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15579' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1641' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1641' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='47366' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47366' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4135' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4135' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='24776' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24776' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='33558' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33558' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='38008' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38008' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='38909' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38909' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='39390' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39390' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46891' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46891' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46893' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46893' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46896' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46896' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| 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() |
| count(*) | sql1 | error_msg |
|---|---|---|
| 1 | INSERT INTO seoclerks.moderator_log (dateline, USERID, editid, type, actiontext, postdata, ipaddress, script, querystring, agent, reason, front_end_mod)
VALUES (UNIX_TIMESTAMP(NOW()), , 666645, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:"lang";s:0:"";}', '', 'cronAIAnalyzeMemDocs.php', '', '', 'Subject: Your identity document "" was rejected on Body: Hi We are sorry to inform you that your identification document has been rejected. Please review the reason for rejection below and resubmit at https://rtest.seoclerks.com/settings/files/identity. Reason for rejection: The file or image you uploaded is broken or corrupt and we are unable to process it. Please try again ensuring the file is not corrupt and is in a supported format.', 1) |
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 666645, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:...' at line 2 rtest.seoclerks.comcronAIAnalyzeMemDocs.php |
| Load | Count | SQL | Max | Min |
