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