SELECT profiles.id, profiles.catgory_id,profiles.address, profiles.profileaccount, profiles.subcat_id, profiles.company_name, profiles.pincode, profiles.phone, profiles.seo_url, profiles.mobile, profiles.fax, profiles.email, profiles.website,profiles.statecountry, profiles.smallbanner, profiles.bigbanner, profiles.shortdescription, profiles.website, area.name as area ,city.name as city FROM profiles INNER JOIN city ON city.id = profiles.city INNER JOIN area ON area.id = profiles.area WHERE (profiles.city="1" OR profiles.mulcity LIKE "%~1~%" ) && profiles.is_delete!=1 && profiles.status=1 && (profiles.d_sc_id="22825" || profiles.subcat_id LIKE "%,22825,%") ORDER BY profiles.profileaccount DESC, profiles.priority DESC limit 0 , 20
  • Useit Yellow Pages
  • Useit Yellow Pages
  • Useit Yellow Pages
Add US

POWDER COATIING COMPANIES In madurai

Listing Search Results

Found 5 records

SEND SMS / E-Mail

Related Category

Popular Search Categories

Follow on Facebook

useit yellowpages madurai