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 = 'firm') OR
(ban_mesto.Type = 'menu' and ban_mesto.Privjazka = '284203') 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 < '1268209699'
AND ban_mesto.Pub_end > '1268209699'
AND ban_mesto.Active = '1'
AND ban_mesto.Ban_ID = ban.ID
Order by ban_mesto.Pub_home desc
firm
Производители лекарств в Энциклопедии лекарств РЛС. Список фармацевтических компаний Буква А Cтраница 1
Энциклопедия лекарств и товаров аптечного ассортимента
-0.12 (2.86%)
© 2000-2010. РЕГИСТР ЛЕКАРСТВЕННЫХ СРЕДСТВ РОССИИ® РЛС®