 |
Watches |
 |
|
|
FEATURING |
|
|
|
NEWSLETTER SIGNUP |
|
|
|
|
|
|
|
|
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 '1283641234 (PRIMARY KEY (products_model)) ENGINE=memory ignore select distinct
' at line 1
create temporary table 1283641234 (PRIMARY KEY (products_model)) ENGINE=memory ignore select distinct
p.products_model,
5 as relevance,
p.products_image,
m.manufacturers_id,
p.products_id,
pd.products_name,
left(pd.products_description, 255) products_description,
p.products_price,
p.products_price1 as msrp,
p.products_tax_class_id,
p.products_quantity,
if(s.status, least(s.specials_new_products_price, p.products_price), p.products_price) as final_price
from products p
left join specials s using(products_id)
left join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_description pd,
products_to_categories p2c,
categories_description cd
where
p.products_status
and p.products_model like '%opticals%'
and p.products_id=pd.products_id
and pd.language_id = '1'
and p.products_id = p2c.products_id
and cd.categories_id = p2c.categories_id
and cd.language_id=1 union select distinct
p.products_model,
match(pd.products_name, pd.products_description) against ('opticals') as relevance,
p.products_image,
m.manufacturers_id,
p.products_id,
pd.products_name,
left(pd.products_description, 255) products_description,
p.products_price,
p.products_price1 as msrp,
p.products_tax_class_id,
p.products_quantity,
if(s.status, least(s.specials_new_products_price, p.products_price), p.products_price) as final_price
from products p
left join specials s using(products_id)
left join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_description pd,
products_to_categories p2c,
categories_description cd
where
p.products_status
and p.products_id = pd.products_id
and pd.language_id = '1'
and p.products_id = p2c.products_id
and cd.categories_id = p2c.categories_id
and cd.language_id=1
and p.manufacturers_id>0
and p.products_quantity>0
and
match(pd.products_name, pd.products_description) against ('+opticals' in boolean mode) > 0.2
order by (products_quantity>1), relevance desc
[TEP STOP]
| | | | |
Shopping Cart:
