The SQL Query:
SELECT tc.totalcount, p.id, p.human, p.userid, p.createdate, p.category, p.title, p.body, p.imageflag, p.online, p.twitteruser, s.slug AS stateslug, s.name AS statename, c.slug AS cityslug, c.name AS cityname, ( SELECT pm5.md5sum FROM photo_md5_post pm5 WHERE pm5.postid=p.id LIMIT 1 ) AS md5sum, (SELECT il.id FROM incall_locations il WHERE il.postid=p.id) AS map, (SELECT id.username FROM im_data id WHERE id.postid=p.id AND id.type='youtube') AS youtube, (SELECT psub.subcategoryid FROM post_subcategory psub WHERE psub.postid=p.id LIMIT 1) AS subcatid, (SELECT CONCAT(pc.email, '&&//==&&', pc.phone) FROM post_contact pc WHERE pc.postid=p.id) AS post_contact_concat, (SELECT CONCAT(cs.id, '&&//==&&', cs.slug, '&&//==&&', cs.name) FROM post_subcity ps, city_subcity cs WHERE ps.postid=p.id AND ps.subcity=cs.id LIMIT 1) AS concat_subcity FROM post p, states s, city c, (SELECT COUNT(*) AS totalcount FROM post p2 WHERE p2.createdate > 0 AND p2.userid=91397) AS tc WHERE p.createdate > 0 AND p.userid=91397 AND p.city=c.id AND c.state=s.id ORDER BY p.online DESC, p.createdate DESC LIMIT 20

Generated the following error:
Subquery returns more than 1 row

vallerie

Page 1