Varukorgen är tom!


Deprecated: Function split() is deprecated in /home/k/konto201/www/karindisajn/includes/functions/general.php on line 681

Produkt sökning

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/k/konto201/www/karindisajn/includes/functions/database.php on line 59
5 - Out of memory (Needed 8388580 bytes)

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) , products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and c.categories_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%jul%' or p.taggar like '%jul%' or p.products_model like '%jul%' or m.manufacturers_name like '%jul%' or p.lagerplats like '%jul%') )