MySQL Error:
SELECT COUNT(DISTINCT P.product_id)
FROM products P
JOIN categories C ON (P.category_id = C.category_id)
JOIN models M ON (P.product_id = M.product_id AND M.active = '1' AND M.deleted = '0')
LEFT JOIN manufacturers MA ON (P.manufacturer_id = MA.manufacturer_id)
LEFT JOIN product_descriptions PD ON (P.product_id = PD.product_id)
WHERE P.models != 0 AND P.deleted = '0' AND P.addon_only = '0'
AND (
M.alu = CONVERT( _utf8 'gamefishing' USING latin1 ) COLLATE latin1_general_ci
OR M.alu LIKE CONVERT( _utf8 'gamefishing%' USING latin1 ) COLLATE latin1_general_ci
OR M.manufacturer_code = CONVERT( _utf8 'gamefishing' USING latin1 ) COLLATE latin1_general_ci
OR M.manufacturer_code LIKE CONVERT( _utf8 'gamefishing%' USING latin1 ) COLLATE latin1_general_ci
OR (1 AND (0 OR CONVERT( 1 USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci OR CONVERT( P.name USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci OR CONVERT( M.name USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci OR CONVERT( C.name USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci OR CONVERT( MA.name USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci OR CONVERT( PD.keywords USING latin1) LIKE CONVERT( _utf8 '%gamefishing%' USING latin1 ) COLLATE latin1_general_ci)))

Server shutdown in progress