[Решено] Модуль Алфавитного поиска по товарам для VM2. - [VM2&3] Модификации и хаки

SELECT SQL_CALC_FOUND_ROWS *
  FROM `q7v6w_virtuemart_products_ru_ru` as l JOIN `q7v6w_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `q7v6w_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `q7v6w_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `q7v6w_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `q7v6w_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE (`product_name` LIKE "%Л%"
  AND p.`published`="1"
  AND (s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ))
  group by p.`virtuemart_product_id`
  ORDER BY product_name ASC
  LIMIT 0, 10

$whereString = ' WHERE ('.implode(' AND ', $where ).') ';

 $keyword = '"%' . $this->_db->getEscaped($this->keyword, true). '%"';

$keyword = '"' . $this->_db->getEscaped($this->keyword, true). '%"';