/brands/engitech/viber:/chat/
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
-- popups_link_pages.url = "/brands/engitech/viber:/chat/"
if popups.child_urls = 1 THEN
LIKE "/brands/engitech/viber:/chat/%"
ELSE
popups_link_pages.url = "/brands/engitech/viber:/chat/"
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
