Notice: Undefined index: profile in /var/www/theclub/data/www/theclub.ru/library/Controller/Frontend.php on line 257
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' to_member_id, from_member_id) AND users.profile_type = 'Member' WHER' at line 3
SELECT COUNT(*) AS posts, (SELECT COUNT(*) AS count FROM friendships INNER JOIN users ON users.profile_id = IF(from_member_id = , to_member_id, from_member_id) AND users.profile_type = 'Member' WHERE (from_member_id = 111 OR to_member_id = 111) AND state = 'accepted' AND users.aasm_state = 'approved') AS friends, (SELECT COUNT(*) AS count FROM transports WHERE user_id = 137 AND state = 'accepted' AND state = 'accepted') AS garage, (SELECT COUNT(*) AS count FROM follows WHERE member_id = 111 AND followable_type = 'Community') AS communities, (SELECT COUNT(*) AS count FROM follows WHERE member_id = 111 AND followable_type = 'Company') AS companies, (SELECT COUNT(*) AS count FROM advertisements WHERE user_id = 137 AND state = 'active') AS advertisements FROM posts WHERE postable_type = 'Member' AND postable_id = 111