
select n.date_available, n.manufacturers_image, n.manufacturers_image2, n.manufacturers_image3, ni.brand_name, ni.description from news n, news_info ni where n.manufacturers_id = ni.manufacturers_id and ni.languages_id = 6 and n.manufacturers_id =
[TEP STOP]