SQL Query Error (SELECT i.*, 
                           m.first_name,m.last_name,users.name as username,
                           c.name as country,
                           s.name as state,
                           s.code as state_code,
                           city.name as city,
                           neighborhood.name as neighborhood,
                           st.name as spa_type,
                           st.id as spa_type_id,                       
                           sl.name as spa_level,
                           cur.name as currency,
                           promo.title as offer
                           
                FROM (items AS i,spa_levels as sl, spa_types as st,
                      countries as c 
                )
                LEFT JOIN item_options AS i_opt ON (i_opt.ref_item=i.id)                                
                    LEFT JOIN members AS m ON (m.ref_user=i.ref_member)
                LEFT JOIN users AS users ON (users.id=i.ref_member)                
                LEFT JOIN states AS s ON (i.ref_state=s.id)                                                
                LEFT JOIN cities AS city ON (i.ref_city=city.id)
                LEFT JOIN neighborhoods AS neighborhood ON (i.ref_neighborhood=neighborhood.id)
                LEFT JOIN currencies AS cur ON (i.ref_currency=cur.id)
                LEFT JOIN promotions AS promo ON (promo.ref_item=i.id AND i.ref_type_level not in (3,6,13,16,19,22,25,28,31))
                WHERE 1
                 AND i.ref_country=c.id
                 AND i.ref_type_level=sl.id                 
                 AND st.id=sl.ref_type
                 
                  AND i.ref_city = 589 AND i.id <> '5883' AND st.id = '1' GROUP BY i.id   ORDER BY i.ref_type_level, RAND() LIMIT 5 ) : Got error -1 from storage engine