Access denied for user ''@'localhost' (using password: NO)
SQL:
SELECT
*,
LOCATE('*', url_pattern)
+ LOCATE('*', url_pattern, LOCATE('*', url_pattern)+1)
+ LOCATE('*', url_pattern, LOCATE('*', url_pattern, LOCATE('*', url_pattern)+1)+1)
+ LENGTH(url_pattern) AS pos,
LOCATE('*', url_pattern) = 0 AS nopos
FROM url_patterns
WHERE TRUE
AND customer_id = 46
AND active = 1
AND '/werkbank-advanced-met-eiken-topblad-in-hoogte-verstelbaar-p0-361591.html' LIKE REPLACE(url_pattern, '*', '%')
ORDER BY nopos DESC, pos DESC