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_link_pages.url IS NOT NULL AND popups.child_urls = 1 THEN LOCATE( popups_link_pages.url, "/product/textar/2115305%" ) WHEN popups_link_pages.url IS NOT NULL AND popups.child_urls = 0 THEN popups_link_pages.url = "/product/textar/2115305" ELSE 1 = 1 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 asc LIMIT 1