Server crashes on SQL select containing more group by and left join statements using innodb tables

SELECT Count(*)

FROM   bpsocial_post AS tbl

       LEFT JOIN bpsocial_profile_object_option a

              ON a.spoo_uid = sspo_uid

                 AND a.spoo_option_id = 1

       LEFT JOIN bpsocial_profile_object_option b

              ON b.spoo_uid = sspo_uid

                 AND b.spoo_option_id = 2

       LEFT JOIN bpsocial_profile_object_option c

              ON c.spoo_uid = sspo_uid

                 AND c.spoo_option_id = 3

       LEFT JOIN bpsocial_profile_object_option d

              ON d.spoo_uid = sspo_uid

                 AND d.spoo_option_id = 5

       LEFT JOIN bpsocial_profile_object_option e

              ON e.spoo_uid = sspo_uid

                 AND e.spoo_option_id = 4

       LEFT JOIN bpsocial_profile_object_option f

              ON f.spoo_uid = sspo_uid

                 AND f.spoo_option_id = 11

       LEFT JOIN bpsocial_profile_object_option g

              ON g.spoo_uid = sspo_uid

                 AND g.spoo_option_id = 7

       LEFT JOIN bpsocial_profile_object_option h

              ON h.spoo_uid = sspo_uid

                 AND h.spoo_option_id = 10

       LEFT JOIN bpsocial_profile_object_option i

              ON i.spoo_uid = sspo_uid

                 AND i.spoo_option_id = 18

       LEFT JOIN bpsocial_profile_object_option j

              ON j.spoo_uid = sspo_uid

                 AND j.spoo_option_id = 6

GROUP  BY a.spoo_value,

          b.spoo_value,

          c.spoo_value,

          d.spoo_value,

          e.spoo_value,

          f.spoo_value,

          g.spoo_value,

          h.spoo_value,

          i.spoo_value,

          j.spoo_value;