|
|
 |
|
Seuraa meitä Facebookissa ja Instagramissa!
|
|
|
|
|
|
|
| Tuotteet jotka täsmäävät hakusi "oryx" kanssa |
|
|
|
| Tuotteet 1 - 30 (66 tuotteesta) |
|
Tulossivut: 1 |
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
[TEP STOP]
| |
