SELECT SQL_CALC_FOUND_ROWS p.virtuemart_product_id, l.product_name, l.product_s_desc, l.product_desc
FROM w2f9n3p4_virtuemart_products as p
LEFT JOIN w2f9n3p4_virtuemart_products_es_es as l ON l.virtuemart_product_id = p.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_product_shoppergroups as ps ON p.virtuemart_product_id = ps.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_product_categories as pc ON p.virtuemart_product_id = pc.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_categories as c ON c.virtuemart_category_id = pc.virtuemart_category_id
LEFT JOIN w2f9n3p4_virtuemart_categories_es_es as cl ON cl.virtuemart_category_id = pc.virtuemart_category_id
WHERE (
(
l.product_name LIKE "%Safety%Helmet%"
OR p.product_sku LIKE "%Safety%Helmet%"
OR l.product_s_desc LIKE "%Safety%Helmet%"
OR l.product_desc LIKE "%Safety%Helmet%"
OR category_name LIKE "%Safety%Helmet%"
OR category_description LIKE "%Safety%Helmet%"
)
AND c.published = 1
AND (
ps.virtuemart_shoppergroup_id= "1"
OR ps.virtuemart_shoppergroup_id IS NULL
)
AND p.published="1"
)
group by p.virtuemart_product_id
ORDER BY p.product_sku ASC, p.virtuemart_product_id ASC
LIMIT 20WHERE MATCH(l.product_name, l.product_s_desc, l.product_desc, category_name, category_description)
AGAINST ('+Safety +Helmet' IN BOOLEAN MODE)$terms = explode(' ', $search);
foreach ($terms as $t) {
$where .= " OR (l.product_name LIKE '%$t%' OR ... )";
}
Page created in 0.489 seconds with 13 queries.