/brands/kennol
SELECT
popups.id,
popups.active,
popups.sort,
popups.date_from,
popups.date_to,
popups.title_ua AS title,
popups.text_ua AS text,
popups.cookie,
popups.img,
popups.timeout
FROM
popups
LEFT JOIN popups_link_pages ON popups_link_pages.popup_id = popups.id
WHERE
-- popups_link_pages.url = "/brands/kennol"
if popups.child_urls = 1 THEN
LIKE "/brands/kennol%"
ELSE
popups_link_pages.url = "/brands/kennol"
END IF
AND popups.date_from < CURRENT_DATE()
AND popups.date_to > CURRENT_TIME()
AND popups.cookie NOT IN ( "PHPSESSID" )
AND popups.active = 1
ORDER BY sort desc
LIMIT 1
