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 = 'pha') OR
(ban_mesto.Type = 'menu' and ban_mesto.Privjazka = '10904538') 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 < '1268209775'
AND ban_mesto.Pub_end > '1268209775'
AND ban_mesto.Active = '1'
AND ban_mesto.Ban_ID = ban.ID
Order by ban_mesto.Pub_home desc
pha
Энциклопедии лекарств РЛС: Фармакологическое действие лекарственных средств - Буква А Страница 1
Энциклопедия лекарств и товаров аптечного ассортимента