""

num_results:1000rowsperpage:100num_results_to:100maxpage:10SELECT item.id_item, item.image_400, item.image_original, item.title, item.title_clean
,MATCH (item.keywords ) AGAINST ('rubinstein+zelda') AS score
FROM `item`
LEFT JOIN `item_movie` ON item_movie.id_item = item.id_item
WHERE item.is_active != 0 AND item.main_id_item_media_video IS NOT NULL
AND MATCH (item.keywords) AGAINST ('+rubinstein+zelda')
GROUP BY item.id_item
ORDER BY score DESC
LIMIT 0, 100