SELECT DISTINCT a.id, a.company_name,a.seo_url,a.contactperson,a.tags,a.address,a.area,a.statecountry, a.city,a.pincode,a.phone,a.mobile,a.email,a.website,area.name as area ,city.name as city, a.shortdescription,a.smallbanner,a.profileaccount,a.bigbanner FROM profiles a INNER JOIN main_category b ON b.id = a.d_mc_id INNER JOIN sub_category d ON d.id = a.d_sc_id INNER JOIN city ON city.id = a.city INNER JOIN area ON area.id = a.area WHERE (a.city= '1' OR a.mulcity LIKE '%~1~%') AND a.status = 1 AND a.profileaccount!=5 AND ((d.name LIKE '%paints%' AND d.name LIKE '%madurai%') OR (b.name LIKE '%paints%' AND b.name LIKE '%madurai%') OR (a.company_name LIKE '%paints%' AND a.company_name LIKE '%madurai%') OR (a.contactperson LIKE '%paints%' AND a.contactperson LIKE '%madurai%') OR (a.phone LIKE '%paints%' AND a.phone LIKE '%madurai%') OR (a.mobile LIKE '%paints%' AND a.mobile LIKE '%madurai%')) ORDER BY a.profileaccount DESC,a.id limit 0 , 20
  • Useit Yellow Pages
  • Useit Yellow Pages
  • Useit Yellow Pages

paints-in-madurai In madurai