SELECT NEWS_DATA.news_data_id,titlos,url_titlos,NEWS_DATA.news_subcategory_id,url,m_keimeno,eisodos,category_en FROM NEWS_SUBCATEGORY INNER JOIN NEWS_CATEGORY ON NEWS_SUBCATEGORY.news_category_id = NEWS_CATEGORY.NEWS_CATEGORY_ID INNER JOIN NEWS_DATA ON NEWS_SUBCATEGORY.news_subcategory_id = NEWS_DATA.NEWS_SUBCATEGORY_ID INNER JOIN news_marka_montelo ON NEWS_data.news_data_id = news_marka_montelo.news_data_id where (ONLINE =1) and (NEWS_DATA.news_subcategory_id IS NOT NULL) and (NEWS_SUBCATEGORY.subcategory<>N'MUST READ') and ((news_marka_montelo.marka + N' ' + news_marka_montelo.montelo=N'AUTOBILD') OR (news_marka_montelo.marka=N'AUTOBILD')) and (NEWS_DATA.magazineid=84) ORDER BY EISODOS DESC,sortcat,ora desc ΕΙΔΗΣΕΙς - AUTOBILD

Ειδησεις - autobild