/brands/azmol
SELECT
popups.id,
popups.active,
popups.sort,
popups.date_from,
popups.date_to,
popups.title_ru AS title,
popups.text_ru AS text,
popups.cookie,
popups.img,
popups.timeout
FROM
popups
LEFT JOIN popups_link_pages ON popups_link_pages.popup_id = popups.id
WHERE
CASE WHEN popups.child_urls = 1 THEN
LOCATE( popups_link_pages.url, "/brands/azmol%" )
ELSE
popups_link_pages.url = "/brands/azmol"
END
AND popups.date_from < CURRENT_DATE()
AND popups.date_to > CURRENT_TIME()
AND popups.cookie NOT IN ( "PHPSESSID" )
AND popups.active = 1
ORDER BY popups.sort desc
LIMIT 1
