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 '/zware-draagarmstelling-vulplaten-voor-ipe-160-ipe180-en-ipe200-staanders-p0-373682.html' LIKE REPLACE(url_pattern, '*', '%')
ORDER BY nopos DESC, pos DESC