Ammotec Finland OY
Seuraa meitä Facebookissa ja Instagramissa!

Tuotteet jotka täsmäävät hakusi "oryx" kanssa
Tuotteet 1 - 30 (66 tuotteesta)
Tulossivut:  1  2  3  [Seuraava >>] 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 30' at line 46

select distinct p.products_id, p.products_model, p.products_prime_id, p.manufacturers_id, if((pl.products_pricetax is not null), if((pl.products_pro_pricetax is not null and pl.products_pro_pricetax > 0),pl.products_pro_pricetax,pl.products_pricetax),p.products_price_tax) as products_price, if((pl.products_pricetax is not null),pl.products_pricetax,p.products_base_price_tax) as products_base_price, p.products_tax_class_id, p.products_quantity, p.products_weight, p.products_date_added, p.products_sales_amount, pd.products_name, pd.products_description, m.manufacturers_name, if(concat(pp.products_pics_dir, pp.products_pics_filename) is not null,concat(pp.products_pics_dir, pp.products_pics_filename),concat(ppm.products_pics_dir, ppm.products_pics_filename)) as products_image, if(s.status and pl.products_id is null, specials_new_products_price_tax, null) as specials_new_products_price, if(pl.products_id is not null,pl.products_pricetax,p.products_price_tax) as final_price, if((p.products_date_added > date_sub(now(),interval 30 day)),true,false) as is_new_product, p.products_is_collection, p.products_is_in_collection, p.products_qty_compare, p.products_compare_unit_code, p.products_rec_type, p.products_is_master from products_description pd, products p left join products pm on (pm.products_prime_id = p.products_master_prime_id) left join products_liteprices pl on (pl.products_id = p.products_id and pl.list_no = 1) left join products_pics ppm on (ppm.products_id = pm.products_id and ppm.products_pics_default='t' and ppm.products_pics_size='mini') left join products_pics pp on (p.products_id=pp.products_id and pp.products_pics_default='t' and pp.products_pics_size='mini') left join manufacturers m on (p.manufacturers_id = m.manufacturers_id) left join specials s on (p.products_id = s.products_id), products_to_categories p2c left join categories c on (p2c.categories_id=c.categories_id) left join categories_description cd on (c.categories_id = cd.categories_id and cd.language_id='1') join user_levels ul on (ul.user_levels_id=2) where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and c.webshow > 0 and ul.categories_webshow >= c.webshow and ((pl.list_no > 0 and pl.products_id is not null) or -1 = 1) and ul.products_webshow >= p.products_webshow and ((pd.products_name like '%oryx%' or p.products_model like '%oryx%' or m.manufacturers_name like '%oryx%' or pd.products_description like '%oryx%') ) and p.products_master_prime_id=0 order by limit 0, 30