
=============================================================================
Time:2023-11-27 20:43:08
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-var_dump(md5(368230801))-'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`Or' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'-var_dump(md5(368230801))-'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:08
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-var_dump(md5(368230801))-'%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'-var_dump(md5(368230801))-'%'
=============================================================================
Time:2023-11-27 20:43:14
Type:sql error
Message:
XPATH syntax error: '~df2eaa8515e3ad2e264e4fe2285bd60'
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and/**/extractvalue(1,concat(char(126),md5(1663145187)))and'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:14
Type:sql error
Message:
XPATH syntax error: '~df2eaa8515e3ad2e264e4fe2285bd60'
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and/**/extractvalue(1,concat(char(126),md5(1663145187)))and'%'
=============================================================================
Time:2023-11-27 20:43:26
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cast(md5(1368608326)as/**/int))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar ' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select'1'from/**/cast(md5(1368608326)as/**/int))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:26
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cast(md5(1368608326)as/**/int))&gt;'0%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select'1'from/**/cast(md5(1368608326)as/**/int))&gt;'0%'
=============================================================================
Time:2023-11-27 20:43:33
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1047087404')as/**/int)&gt;0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`Or' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456/**/and/**/cast(md5('1047087404')as/**/int)&gt;0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:33
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1047087404')as/**/int)&gt;0%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456/**/and/**/cast(md5('1047087404')as/**/int)&gt;0%'
=============================================================================
Time:2023-11-27 20:43:41
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MD5','1765378383')))%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1765378383')))%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:41
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MD5','1765378383')))%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1765378383')))%'
=============================================================================
Time:2023-11-27 20:43:47
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1808569697')))&gt;'0%' ORDER BY a.`O' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and/**/convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1808569697')))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:47
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1808569697')))&gt;'0%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and/**/convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1808569697')))&gt;'0%'
=============================================================================
Time:2023-11-27 20:43:53
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456鎈'&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:43:53
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&quot;\(%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456鎈'&quot;\(%'
=============================================================================
Time:2023-11-27 20:44:00
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:44:00
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&quot;\(%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'&quot;\(%'
=============================================================================
Time:2023-11-27 20:44:13
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(0))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:44:13
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(0))a/**/union/**/select+1)='%'
=============================================================================
Time:2023-11-27 20:44:22
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(6))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:44:28
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(6))a/**/union/**/select+1)='%'
=============================================================================
Time:2023-11-27 20:44:39
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:44:46
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%'
=============================================================================
Time:2023-11-27 20:44:56
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:45:03
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%'
=============================================================================
Time:2023-11-27 20:45:14
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2023-11-27 20:45:21
Type:sql error
Message:
Subquery returns more than 1 row
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%123456'and(select*from(select+sleep(7))a/**/union/**/select+1)='%'