SELECT ban_mesto.`Type` as `Type`, ban_mesto.ID as Mesto_ID, ban_mesto.Ban_ID, ban_mesto.Mesto, ban.Title,
ban.Href, ban.Width, ban.Height, ban.Image, ban_mesto.Target
FROM rlsnet.ban_mesto, rlsnet.ban
WHERE
((ban_mesto.Type IN ('page', 'query') and ban_mesto.Privjazka = 'atc_tree') OR
(ban_mesto.Type = 'menu' and ban_mesto.Privjazka = '385181') OR
((ban_mesto.Type = 'module') AND (ban_mesto.Privjazka = 1)) OR
(ban_mesto.Type = 'vse' and ban_mesto.Privjazka = '0'))
AND ban_mesto.Pub_home < '1268209735'
AND ban_mesto.Pub_end > '1268209735'
AND ban_mesto.Active = '1'
AND ban_mesto.Ban_ID = ban.ID
Order by ban_mesto.Pub_home desc
atc_tree
АТХ классификация Справочник лекарств РЛС: лекарственные средства и препараты в Энциклопедии лекарств РЛС. Инструкция, применение, описание и цена лекарств
Энциклопедия лекарств и товаров аптечного ассортимента