SELECT t2.dbs_page_name,
t4.dbs_page_txt,
t5.dbs_url
FROM dbs_rule AS t1
LEFT JOIN dbs_page AS t2 ON (t2.dbs_id=t1.dbs_id)
LEFT JOIN dbs_structure AS t3 ON (t3.dbs_id=t1.dbs_id)
LEFT JOIN dbs_page_txt AS t4 ON (t4.dbs_rule_id=t1.dbs_rule_id)
LEFT JOIN dbs_url AS t5 ON (t5.dbs_id=t1.dbs_id AND t5.dbs_url_main='1')
WHERE t1.dbs_rule_metka = 'NONEWS' AND
t3.dbs_lang_id = '4'
AND t1.dbs_id <> ''
LIMIT 1
Акції та знижки
