SQL Query Error
(SELECT item.*, item_type.name AS type_name, item_type.action AS type_action, item_status.name AS status_name, 
                       item_format.name AS item_format_name, company.name AS studio, video.ref_item, video.ref_company, video.running_time, video.ref_mpaa_rating, video.languages, video.subtitles, video.aspect_ratios, video.rating, video.review_count,  CONCAT('http://www.hmongflix.com/materials/items/', LEFT(item.id, 1), '/', item.id, '/full', '.jpg') AS full_image_file_src ,  CONCAT('http://www.hmongflix.com/materials/items/', LEFT(item.id, 1), '/', item.id, '/thumbnail', '.jpg') AS thumbnail_image_file_src ,  CONCAT('http://www.hmongflix.com/materials/items/', LEFT(item.id, 1), '/', item.id, '/detail', '.jpg') AS detail_image_file_src 
 , if (item.position <> 0, item.id, 0) as serie_up_id,
                        if (item.position <> 0, item.id, 0) as serie_down_id
, item.position serie_position, video.rating as item_rating
                FROM (items AS item
                INNER JOIN item_types AS item_type ON item.ref_type = item_type.id
                INNER JOIN item_statuses AS item_status ON item.ref_status= item_status.id
                INNER JOIN item_formats AS item_format ON item.ref_format = item_format.id
                INNER JOIN videos AS video ON video.ref_item = item.id
                
                )

                LEFT JOIN video_genre_references AS video_genre_reference ON video_genre_reference.ref_video = item.id
                LEFT JOIN video_genres AS video_genre ON video_genre_reference.ref_genre = video_genre.id

                LEFT JOIN video_companies AS company ON video.ref_company = company.id   
                                              
                  WHERE 1  AND item.id <> 1105 AND item.ref_type = '1'  AND item.ref_status = 1 AND item.ref_item_serie = 0 AND video_genre.id in (SELECT video_genre_similar.id 
                                              FROM video_genres as video_genre_similar, video_genre_references AS video_genre_reference_similar
                                              WHERE video_genre_reference_similar.ref_video = 1105 
                                                    AND video_genre_reference_similar.ref_genre = video_genre_similar.id 
                                             ) GROUP BY item.id  ORDER BY  rating DESC LIMIT 12 )
:
Got error 122 from storage engine