SELECT   ztzimers.id,ztzimers.name,ztzimers.url,ztzimers.phone1,ztzimers.cordes_zimmer,ztzimers.price_min,ztzimers.price_min_wday,ztzimers.city_id,ztzimers.area_id,ztzimers.summary,ztzimers.num_rates,ztzimers.amount, images.location img_location, images.show_pics_nums , areas.name areaName, areas.url areaUrl, yashuv.name cityName, yashuv.url cityUrl FROM ztzimers
            left join images on(ztzimers.id=images.tzimer_id)
             left join areas on(ztzimers.area_id=areas.id) left join yashuv on(ztzimers.city_id=yashuv.id) LEFT JOIN tzimers_sub_cat AS tz_sub ON (ztzimers.id=tz_sub.tzimer_id ) LEFT JOIN ztzimers_cats on (ztzimers.id =ztzimers_cats.`zimer_id`)
                where ztzimers.`active` = '1' and ztzimers.instance_id='0'  and (ztzimers_cats.cat_id='' OR (tz_sub.sub_id_='1' and advancement_by_sub='1')) group by ztzimers.id ORDER BY RAND() LIMIT 5Unknown column 'tz_sub.sub_id_' in 'where clause'