SELECT DISTINCT u.id, u.username, u.lastname, u.gender, u.price, u.phone_no, u.telehealth_url, u.website_url, u.country, u.state, u.city, u.district, u.zip, u.avatar, u.resume, u.resumeStatus, u.booknow, u.companyname, u.profilename, u.speciality, u.profileLicense, u.experience, u.experience_plus, u.timeslot, u.longitude, u.latitude, u.active, u.userType, u.lastvisitDate, u.therapistActive, u.therapistActiveType, u.therapistFeature, u.profileUpdateDate, u.primary_latitude, u.primary_longitude, u.secondary_latitude, u.secondary_longitude, u.registerDate, u.lastvisitDate, t.personalDetail, t.location, t.description, t.qualification, t.finance, t.social, t.configuration
FROM psy_therapist AS t
INNER JOIN psy_users AS u ON t.usersID = u.id AND u.active = 1 AND u.accountType = 'register' AND (u.userType = 'therapist' OR u.userType = 'clinic')
LEFT JOIN (SELECT ageGroupID, status, usersid from psy_therapist_agegroup ta ,psy_therapist_agegroupjoin taj WHERE ta.id = taj.ageGroupID) agr ON agr.usersid = u.id
LEFT JOIN (SELECT issueID, status, usersid from psy_therapist_issue ti ,psy_therapist_issuejoin tij WHERE ti.id = tij.issueID) issr ON issr.usersid = u.id
LEFT JOIN (SELECT therapytypeID, status, usersid from psy_therapist_therapytype tt ,psy_therapist_therapytypejoin ttj WHERE tt.id = ttj.therapytypeID) ttjr ON ttjr.usersid = u.id
LEFT JOIN (SELECT insuranceID, status, usersid from psy_therapist_insurance tins ,psy_therapist_insurancejoin tinsj WHERE tins.id = tinsj.insuranceID) tinsjr ON tinsjr.usersid = u.id
LEFT JOIN psy_therapist_speciality AS ttt ON t.specialityID = ttt.id
WHERE u.id = '884'
Pinaki Sarkar, Psychiatrist, Kolkata, West Bengal, 741235 - Psychology India
Don't be shy. Our therapists are here to help you and are pleased to hear from you.
Feel free to ask for what you want… an appointment, a consultation or simply a response to a question.
Remember to double check your return email address or your phone number if you prefer to be called.
Psychology India does not read or retain your e-mail. However, a copy will be sent to you for your records. Please be aware that e-mail is not a secure means of communication and spam filters may prevent your e-mail from reaching the therapist. The therapist should respond to you by e-mail, although we recommend that you follow up with a phone call. If you prefer corresponding via phone, leave your contact number.
Sending an email using this page does not guarantee that the recipient will receive, read or respond to your email.
If this is an emergency do not use this form. Call 911 or your nearest hospital.
Share - Psychiatry Clinic
Your message will automatically include the following information about the therapist.
Warning: Undefined property: stdClass::$userType in /home/cp10therasoftsit/public_html/PSYCHOLOGYINDIA/application/views/therapist/therapist_detail.php on line 1258
Warning: Undefined property: stdClass::$userType in /home/cp10therasoftsit/public_html/PSYCHOLOGYINDIA/application/views/therapist/therapist_detail.php on line 1258
Warning: Undefined property: stdClass::$userType in /home/cp10therasoftsit/public_html/PSYCHOLOGYINDIA/application/views/therapist/therapist_detail.php on line 1258
Therapists List
Warning: Undefined property: stdClass::$companyname in /home/cp10therasoftsit/public_html/PSYCHOLOGYINDIA/application/views/therapist/therapist_detail.php on line 1262