vmxsearch.plugin.php неверные результаты поиска - [VM1] Общие вопросы и ошибки

 $query = "SELECT DISTINCT p.product_id, p.product_name as title,
					FROM_UNIXTIME( p.cdate, '%Y-%m-%d %H:%i:%s'  ) AS created,
					p.product_s_desc AS text,
					CONCAT('$ItemName/',c.category_name) as section,
					CONCAT(IF(c.category_id=7,'printery-i-mfu.html','rashodka.html'),'?page=shop.product_details&flypage=',IFNULL(c.category_flypage,'" . FLYPAGE . "'),'&product_id=',p.product_id,'&category_id=',IFNULL(c.category_id,'')) as href,
					'2' as browsernav 
					$whole_text 
					FROM #__vm_product p
					LEFT JOIN #__vm_product_reviews r ON (r.product_id = p.product_id) 
					LEFT JOIN #__vm_product_mf_xref mx ON (mx.product_id = p.product_id) 
					LEFT JOIN #__vm_manufacturer m ON (m.manufacturer_id = mx.manufacturer_id),
						#__vm_product_category_xref cx, #__vm_category c
						WHERE ($where)" . "\n AND cx.product_id = p.product_id
							AND cx.category_id = c.category_id $parent_where
							AND c.category_publish='Y'
							AND p.product_publish='Y'
					$oos_where
					ORDER BY $order" ;