Automotive     AUTOPROMOTEC 2009     Company Profile     Products     Distributors     Approvals     Corghi World Wide     Gallery     You can find us at...     Links     Press     Contacts    
SELECT news_id, news_date, news_group, news_priority, news_photo_2 AS news_photo, news_pdf_2 AS news_pdf, news_link_2 AS news_link, news_title_2 AS news_title, news_descr_2 AS news_descr, ord_categ, flag2, flag3, news_all FROM tbl_news WHERE flag2 != '1' AND flag3 != '1' AND (news_date_end IS NULL OR news_date_end > NOW()) AND ( (news_priority = 0) AND (isnull(news_group) OR news_group ='') ) and news_title_2!=''