HARSHITKUMAR ZAVERI

SELECT DISTINCT('c.cat_id'),c.cat_name,c.cat_url,ct.city_id,ct.city_name,ut.ut_name FROM user_category AS uc INNER JOIN category AS c ON c.cat_id = uc.uc_category_id INNER JOIN user AS u ON u.user_id = uc.uc_user_id INNER JOIN user_detail AS ud ON u.user_id = ud.user_id INNER JOIN city AS ct ON ct.city_id = ud.office_city_id INNER JOIN user_types AS ut ON ut.ut_id = u.user_type_id WHERE uc.uc_user_id = 102