ProjectList

SELECT r.*, u.username, u.company_name, u.mobile_no, u.email, u.city AS owner_city FROM rentdata_tbl r LEFT JOIN registration u ON r.owner_id = u.id WHERE u.isActive = '1' AND r.city = 'Mumbai City' ORDER BY r.id DESC ProjectList