Надо ли менять левую часть запроса

Собственно вот наш красавец

Код (Text):

1. SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
2.   FROM `cms_virtuemart_products_ru_ru` as l JOIN `cms_virtuemart_products` AS p using (`virtuemart_product_id`)
3.  
4.  
5.   LEFT JOIN `cms_virtuemart_product_categories`
6.   ON p.`virtuemart_product_id` = `cms_virtuemart_product_categories`.`virtuemart_product_id`
7.  
8.  
9.   LEFT JOIN `cms_virtuemart_categories_ru_ru` as c
10.   ON c.`virtuemart_category_id` = `cms_virtuemart_product_categories`.`virtuemart_category_id`
11.  
12.  
13.  
14.  
15.   LEFT JOIN `cms_virtuemart_product_manufacturers`
16.   ON p.`virtuemart_product_id` = `cms_virtuemart_product_manufacturers`.`virtuemart_product_id`
17.  
18.  
19.   LEFT JOIN `cms_virtuemart_manufacturers_ru_ru` as m
20.   ON m.`virtuemart_manufacturer_id` = `cms_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
21.  
22.  
23.  
24.  
25.  
26.   LEFT JOIN `cms_virtuemart_product_shoppergroups`
27.   ON p.`virtuemart_product_id` = `cms_virtuemart_product_shoppergroups`.`virtuemart_product_id`
28.  
29.   LEFT
30.   OUTER JOIN `cms_virtuemart_shoppergroups` as s
31.  
32.  
33.   ON s.`virtuemart_shoppergroup_id` = `cms_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
34.  
35.  
36.   WHERE ((`product_name` LIKE "%GENEVRIER%" OR `product_s_desc` LIKE "%GENEVRIER%" OR `category_name` LIKE "%GENEVRIER%" OR `category_description` LIKE "%GENEVRIER%" OR `mf_name` LIKE "%GENEVRIER%")
37.  
38.  
39.   AND p.`published`="1"
40.  
41.  
42.   AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
43.   group by p.`virtuemart_product_id`
44.   ORDER BY product_name ASC
45.   LIMIT 0, 10

Мне надо дополнить этот запрос на фильтрацию по значению дополнительного поля
Спасибо