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="141674" || profiles.subcat_id LIKE "%,141674,%") ORDER BY profiles.profileaccount DESC, profiles.priority DESC limit 0 , 20
