string(1118) "
Select ad.ad_id, ad.title, ad.photo, ad.price, ad.currency_id, DATE_FORMAT(ad.reg_date, '%d-%m-%Y') as ad_date,
city.label as city_label, town.label as town_label, county.label as county_label, ad.city2, ad.town2, ad.city_id,
ad.s_urgent, ad.s_discount, ad.s_flash, ad.s_toplist, ad.has_get,
ad.c1_id,ad.c2_id,ad.c3_id,ad.c4_id,ad.c5_id, ad.shop_id, ad.shop_url, ad.pname,
c1.label as c1label, c2.label as c2label, c3.label as c3label, c4.label as c4label, c5.label as c5label
From zt_3226 as ad
Left Join category as c1 on(ad.c1_id = c1.category_id)
Left Join category as c2 on(ad.c2_id = c2.category_id)
Left Join category as c3 on(ad.c3_id = c3.category_id)
Left Join category as c4 on(ad.c4_id = c4.category_id)
Left Join category as c5 on(ad.c5_id = c5.category_id)
Left Join city on(ad.city_id = city.city_id)
Left Join town as county on(ad.town_id = county.town_id)
Left Join town on(county.parent = town.town_id)
Where (ad.c1_id ='3226' or ad.c2_id ='3226' or ad.c3_id ='3226' or ad.c4_id ='3226' or ad.c5_id ='3226')
"