Searching Whole Word

Please post your questions and problems with any of our extensions which you are using

Searching Whole Word

Postby spike1968 » Fri Aug 09, 2019 12:55 pm

Hi Stan,

I am trying to work out where to alter the search functions to enable "whole word" search only.

For example if I search "Hand Soap" it will return products with the word "Handle". So as well as hand soap products it returns cutlery (handle), cloths (hand), pans (handle) even serving platters with handles. I know I can configure by various search priorities, but there is no combination that will do that effectively. If I exclude descriptions and custom fields I then get limited results in the drop down.

I need the search to return products where phrases like "Hand Soap" only returns products with "Hand Soap" in the description/short description/Custom Fields rather than returning products with "Hand Cloth" or "Aluminium Handle" etc,.

The other issue are the results returned if I hit enter, they still return all products even if I exclude certain options in the search prioritise.

Is it possible to create a template override to search with whole phrases only?
If so which template would I need to make this happen with the ajax search drop down?
Which template would I need to alter to make this happen when the user just hits return? Would that be a vm3 template or rupsearch?

Many Thanks for your help again
spike1968
 
Posts: 16
Joined: Thu Nov 24, 2016 10:14 am

Re: Searching Whole Word

Postby admin » Fri Aug 09, 2019 1:39 pm

hello, this is what i suggest to do:
- if your priority is description and custom fields
- i suggest to alter priorities by dragging short + long description to the top (custom fields may be a bit more tricky)
- and enable the debug within the module (ajax search pro)
- disable single query (only multiple queries are supported in the latest versions)

this will then render SQL queries into javascript browser per the search results found.

example of the output after i moved short + long description to the top:

Code: Select all
query ["PRODUCT_S_DESC","PRODUCT_DESC","PRODUCT_SKU","PRODUCT_NAME","PRODUCT_NAME_WORDS","PRODUCT_SKU_STARTS_WITH","MF_NAME","PRODUCT_SKU_ENDS","PRODUCT_SKU_WITHOUT_SPACE","PRODUCT_MPM","PRODUCT_GTIN","PRODUCT_NAME_MULTI_WORDS"]
13:28:17.545 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:712 query "(31):  select  DISTINCT  2119 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  ( l.`product_s_desc` LIKE '%máčané v polyuretáne%'  OR ( (  l.`product_desc` LIKE '%máčan%' )  AND  (  l.`product_desc` LIKE '%v %' )  AND  (  l.`product_desc` LIKE '%polyuret%' ) ) ) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.550 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:718 query "(6): select  DISTINCT  2089 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  ( l.`product_desc` LIKE '%máčané v polyuretáne%'  OR ( (  l.`product_s_desc` LIKE '%máčan%' )  AND  (  l.`product_s_desc` LIKE '%v %' )  AND  (  l.`product_s_desc` LIKE '%polyuret%' ) )  ) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.555 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:724 query "(0):  select  DISTINCT  1390 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ((( p.`product_sku` LIKE 'máčané v polyuretáne%') or ( p.`product_sku` = 'máčané v polyuretáne%'))  or ((( childs.`product_sku` LIKE 'máčané v polyuretáne%') or ( childs.`product_sku` = 'máčané v polyuretáne%')) and childs.`published` = '1' ) )  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107)   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.558 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:730 query "(0):  select  DISTINCT  1441 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ((( l.`product_name` LIKE 'máčané v polyuretáne' ) or (( l.`product_name` = 'máčané v polyuretáne%' )))  or ((( lchilds.`product_name` LIKE 'máčané v polyuretáne' ) or (( lchilds.`product_name` = 'máčané v polyuretáne%' ))) and childs.`published` = '1' ) )   and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.558 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:736 query "(0):  select  DISTINCT  1441 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ((( l.`product_name` LIKE 'máčané v polyuretáne' ) or (( l.`product_name` = 'máčané v polyuretáne%' )))  or ((( lchilds.`product_name` LIKE 'máčané v polyuretáne' ) or (( lchilds.`product_name` = 'máčané v polyuretáne%' ))) and childs.`published` = '1' ) )   and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.559 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:742 query "(5):  select  DISTINCT  1497 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ( ( l.`product_name`  LIKE '%máčané v polyuretáne')  or ( lchilds.`product_name`  LIKE '%máčané v polyuretáne') and childs.`published` = '1' )   and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.559 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:748 query "(0):  select  DISTINCT  1526 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and    ((l.`product_name` LIKE '% máčané v polyuretáne %') or ((lchilds.`product_name` LIKE '% máčané v polyuretáne %') and childs.`published` = '1'))  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.560 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:754 query "(0):  select  DISTINCT  1549 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   l.`product_name` LIKE '%máčané v polyuretáne%'  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.560 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:760 query "(0):  select  DISTINCT  1482 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ( (( l.`product_name` LIKE 'máčané v polyuretáne%' ) or (( l.`product_name` = 'máčané v polyuretáne%' )))  or ((( lchilds.`product_name` LIKE 'máčané v polyuretáne%' ) or (( lchilds.`product_name` = 'máčané v polyuretáne%' ))) and childs.`published` = '1' ) )  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.561 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:766 query "(0):  select  DISTINCT  1512 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ( ( l.`product_name`  LIKE 'máčané v polyuretáne%')  or (( lchilds.`product_name`  LIKE 'máčané v polyuretáne%') and childs.`published` = '1'))  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.561 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:772 query "(0):  select  DISTINCT  1541 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   l.`product_name` LIKE '% máčané v polyuretáne %'  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.562 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:778 query "(0):  select  DISTINCT  1559 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   l.`product_name` LIKE '%máčané v polyuretáne%'  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.562 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:784 query "(0):  select  DISTINCT  1604 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where  (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   l.`product_name` LIKE '%máčané%v%polyuretáne%'  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.564 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:790 query "(0):  select  DISTINCT  1616 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where  (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   l.`product_name` = '%máčané%v%polyuretáne%'  and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.564 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:796 query "(0):  select  DISTINCT  1711 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  ( l.`product_name` LIKE ' máčané v polyuretáne %') and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`   and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.565 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:802 query "(0):  select  DISTINCT  1726 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  (0  OR ( (  l.`product_name` LIKE '%máčan%' )  AND  (  l.`product_name` LIKE '%v %' )  AND  (  l.`product_name` LIKE '%polyuret%' ) ) ) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`   and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.565 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:808 query "(0):  select  DISTINCT  2028 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and    (p.`product_sku` LIKE 'máčané v polyuretáne%' or ((( childs.`product_sku` LIKE 'máčané v polyuretáne%') ) and childs.`published` = '1' ) )  and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.566 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:814 query "(0):  select  DISTINCT  1672 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_product_manufacturers` as pm, `vepao_virtuemart_manufacturers_sk_sk` as m )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  ( m.`mf_name` LIKE 'máčané v polyuretáne%'  ) and p.`published` = '1' and p.`virtuemart_product_id` = pm.`virtuemart_product_id` and pm.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.567 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:820 query "(0):  select  DISTINCT  2046 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   ( p.`product_sku` LIKE '%máčané v polyuretáne%' or ((( childs.`product_sku` LIKE '%máčané v polyuretáne%') ) and childs.`published` = '1' ) )  and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.568 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:826 query "(0):  select  DISTINCT  1921 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  (( p.`product_sku` LIKE 'máčanévpolyuretáne%') or ( p.`product_sku` = 'máčanévpolyuretáne%')) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.569 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:832 query "(0):  select  DISTINCT  1932 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  (( p.`product_mpn` LIKE 'máčanévpolyuretáne%') or ( p.`product_mpn` = 'máčanévpolyuretáne%')) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.571 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:838 query "(0):  select  DISTINCT  1942 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  (( p.`product_gtin` LIKE 'máčanévpolyuretáne%') or ( p.`product_gtin` = 'máčanévpolyuretáne%')) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.571 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:844 query "(0):  select  DISTINCT  1953 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_sku` LIKE 'máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.572 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:850 query "(0):  select  DISTINCT  1965 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_sku` LIKE '%máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.573 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:856 query "(0):  select  DISTINCT  1975 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_mpn` LIKE 'máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.573 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:862 query "(0):  select  DISTINCT  1987 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_mpn` LIKE '%máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.574 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:868 query "(0):  select  DISTINCT  1999 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_gtin` LIKE 'máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.575 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:874 query "(0):  select  DISTINCT  2011 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_gtin` LIKE '%máčanévpolyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.575 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:880 query "(0):  select  DISTINCT  1862 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id`, p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  (( p.`product_gtin` LIKE 'máčané v polyuretáne%') or ( p.`product_gtin` = 'máčané v polyuretáne%')) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)   order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.576 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:886 query "(0):  select  DISTINCT  1885 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_gtin` LIKE 'máčané v polyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.583 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:892 query "(0):  select  DISTINCT  1897 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and   p.`product_gtin` LIKE '%máčané v polyuretáne%' and p.`published` = '1'  and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "
13:28:17.584 index.php?option=com_rupsearch&view=search&nosef=1&lang=sk&language=sk-SK&order_by=&Itemid=1422&product_keyword=máčané+v+polyuretáne&opt_search=0&module_id=766&view=search&limitstart=0&Search=&view=search&option=com_rupsearch:898 query "(0):  select  DISTINCT  1792 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD  from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l )  LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id`  LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id`  LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id`  where (  (`sg`.`virtuemart_shoppergroup_id` = 2) or  ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) )  and  p.`product_parent_id` = 0  and  ( l.`product_name` LIKE '%máčané v polyuret%'  OR ( (  l.`product_name` LIKE '%máčan%' )  AND  (  l.`product_name` LIKE '%v %' )  AND  (  l.`product_name` LIKE '%polyuret%' ) ) ) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id`  and  p.`virtuemart_product_id` NOT IN (56027,28267,34737,34879,27894,55552,55559,29063,28521,27899,56051,56056,29579,29578,28519,28071,27886,34670,55964,57143,57148,58510,57172,28869,33627,19596,28871,28294,28520,55971,28296,34748,34753,55918,57126,57152,57107,28070,28900,28290,55924,55930)  order by SORTFIELD asc  LIMIT 0,49 "



my search keyword was "máčané v polyuretáne" (meaning washed in plyuretan)

what this does with:
select DISTINCT 2119 as `qn`, p.`virtuemart_product_id`, p.`product_parent_id` , p.pordering as SORTFIELD from (`vepao_virtuemart_products` AS p, `vepao_virtuemart_products_sk_sk` as l ) LEFT JOIN `vepao_virtuemart_product_shoppergroups` as sg ON p.`virtuemart_product_id` = sg.`virtuemart_product_id` LEFT JOIN `vepao_virtuemart_products` as childs ON p.`virtuemart_product_id` = childs.`product_parent_id` LEFT JOIN `vepao_virtuemart_products_sk_sk` as lchilds ON childs.`virtuemart_product_id` = lchilds.`virtuemart_product_id` where ( (`sg`.`virtuemart_shoppergroup_id` = 2) or ( `sg`.`virtuemart_shoppergroup_id` IS NULL ) ) and p.`product_parent_id` = 0 and ( l.`product_s_desc` LIKE '%máčané v polyuretáne%' OR ( ( l.`product_desc` LIKE '%máčan%' ) AND ( l.`product_desc` LIKE '%v %' ) AND ( l.`product_desc` LIKE '%polyuret%' ) ) ) and p.`published` = '1' and p.`virtuemart_product_id` = l.`virtuemart_product_id` order by SORTFIELD asc LIMIT 0,49 "


is that the very first products that are shown to the customer are those that match

( l.`product_s_desc` LIKE '%máčané v polyuretáne%' OR ( ( l.`product_desc` LIKE '%máčan%' ) AND ( l.`product_desc` LIKE '%v %' ) AND ( l.`product_desc` LIKE '%polyuret%' ) ) )

to adjust this, i'll need to modify the module (for the new priority) and then com_rupsearch (helper.php where the SQL's are)

to create a new "priority" that separates this into two queries. (S_DESC_EXACT_PHRASE vs S_DESC_WORDS_MATCH )

if you are a developer, i could remake this into a system where you could adjust the queries via the templates (right now it's not the case as they are in core helper files and get overwritten upon update)

but our main goal for this system right now is to switch to elastic search engine support since it has much faster responses for text search compared to mysql. we are using 2 dedicated servers - one that runs the website and mysql and the other would run elastic (and emails, etc..)

to get this into elastic we need to create CRON CLI script that syncs the products daily to elastic DB and adjust com_rupsearch to be able to connect to elastic search and return results per defined priorities.

let me know if you are interested in elastic search, or if you want us to "quickly create new priorities" for your needs, or "slowly add extension support via templates where you could define your own queries" and name your own priorities.

(elastic db can be self-hosted on a dedicated server with spare 64gb ram or via cloud providers - it normally costs a few hundreds of dollars monthly)

best regards, stan
admin
Site Admin
 
Posts: 2593
Joined: Wed Jan 06, 2010 11:43 pm

Re: Searching Whole Word

Postby spike1968 » Fri Aug 09, 2019 2:57 pm

Hi Stan,

Thanks for the prompt response, that was quick even by your standards :)

Got your email and I'm impressed that you have already added a new template file. adding new priorities and adjusting config to accommodate.

I await the new version with anticipation :)

Elastic search is new to me, I will have to read up on that :) I run my own dedicated servers so it may be something for the future.

Once again fantastic support and brilliant solutions. I will update this post once I have tested...

Cheers
Martyn
spike1968
 
Posts: 16
Joined: Thu Nov 24, 2016 10:14 am

Re: Searching Whole Word

Postby admin » Thu Sep 26, 2019 12:33 pm

hello martyn, let me know if there is anything to be done in this matter, our search is being used by our largest customers. the best config is not to use the ajax driven results as this will lead to huge server load which searches the keyword per every letter entered. if you got tens of thousands of products the search is very slow and it's better to show just the most relevant results when an enter key is pressed.

best regards, stan
admin
Site Admin
 
Posts: 2593
Joined: Wed Jan 06, 2010 11:43 pm


Return to VirtueMart and Joomla Extensions (free or paid)