:: Agjensi Autobuzash - Tiranë ::

SELECT SQL_NO_CACHE companies2.company2_id, companies2.company_id, companies2.region_id, companies2.area_id, companies2.flag_correct_entry, companies.title_gr, companies.address, companies.tel, companies.tel2, companies.fax, companies.email, companies.website, companies.website2, companies.description, companies.sponsor_small_banner, sponsors.sponsor_id, regions.title_gr AS regSpTit, areas.title_gr AS areaSpTit FROM (((companies2 INNER JOIN companies ON companies2.company_id=companies.company_id) INNER JOIN sponsors ON companies2.company2_id=sponsors.company2_id) INNER JOIN regions ON companies2.region_id=regions.region_id) INNER JOIN areas ON companies2.area_id=areas.area_id WHERE sponsors.category_id=6 AND companies2.show_publicity=1 AND ((sponsors.region_id=0 AND sponsors.area_id=0) OR (sponsors.region_id=1 AND sponsors.area_id=0)) ORDER BY RAND();