Error Number: 1242
Subquery returns more than 1 row
SELECT *, (select GROUP_CONCAT(SubCategory) from subcategorymaster where SubCategoryId IN (SELECT SubCategoryId FROM tbl_cele_crew_category WHERE CelebrityId = filmcrew.filmcrew_Id))as SubCategory, (select ProfilePhoto from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as ProfilePhoto, (select DOB from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as dob, (SELECT CityName FROM city WHERE CityId = (select NativePlace from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id))as native_place, (select About from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as About, (select FBPage from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as FBPage, (select Twitter from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as Twitter, (select Website from celebrityprofile where CelebrityId=filmcrew.filmcrew_Id)as Website from filmcrew where slug = "ankush-hazra"
Filename: /home/indianfilm/public_html/models/indianfilmindustry_fm.php
Line Number: 413