MVD Entertainment Group: Serving Artists & Audiences

Invalid query 192: SELECT c.stock_num, c.descr, c.cat, c.genre, c.mvd_exclusive, c.label, c.barcode, DATE_FORMAT(c.release_date,'%m/%d/%y') as release_date, c.vendor, DATE_FORMAT(c.prebook_date,'%m/%d/%y') as prebook_date, c.msrp, c.runtime, c.num_discs, c.audio, c.boxlot, c.year_of_production, c.priority, c.featured, c.artist, c.price_change_date, c.change_date, c.change_reason, c.img_name, c.level1, c.level2, c.territories, c.alt_genre, c.region, e.title, e.first_name, e.last_name, e.first_name_2, e.last_name_2, e.first_name_3, e.last_name_3, e.tag_line, e.director, e.producers, e.actors, e.minisite_url, e.press_exists, e.300dpi_exists, e.salessheet_exists,e.salessheet_digital_exists, e.72dpi_exists, e.art_3d, e.art_exploded, e.language,e.label_id, e.release_version, g.name, f.short_descr AS format_name, MATCH(search_text_short) AGAINST ('+steel%2bvengeance') AS score FROM catalog_search INNER JOIN catalog c ON catalog_search.stock_num = c.stock_num INNER JOIN sw_category_codes f ON c.cat = f.cat AND c.loc_num = f.loc_num LEFT JOIN extended_data e ON e.stock_num = c.stock_num INNER JOIN genres g ON c.genre = g.id WHERE (match(search_text_short) against('+steel%2bvengeance' IN%2BBOOLEAN%2BMODE)):You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%2BBOOLEAN%2BMODE))' at line 1