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 '/gereedschapshouders-met-klemopening-p0-361750.html' LIKE REPLACE(url_pattern, '*', '%')
ORDER BY nopos DESC, pos DESC