|
|
| Search Results for - Humidor OR Kit OR Gift OR Lighter OR Case OR Hygrometer OR Cutter OR Ashtray OR Sample |
|
 |
| Displaying 1 to 7 (of 7 products) |
Result Pages: 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 1
select distinct p.products_image, m.manufacturers_id, p.products_id, p.products_quantity, pd.products_name, pd.products_description, p.products_qty, p.vendors_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%humidor%' or p.products_model like '%humidor%' or p.products_shape like '%humidor%' or m.manufacturers_name like '%humidor%' or pd.products_description like '%humidor%' or pd.short_desc like '%humidor%') or (pd.products_name like '%kit%' or p.products_model like '%kit%' or p.products_shape like '%kit%' or m.manufacturers_name like '%kit%' or pd.products_description like '%kit%' or pd.short_desc like '%kit%') or (pd.products_name like '%gift%' or p.products_model like '%gift%' or p.products_shape like '%gift%' or m.manufacturers_name like '%gift%' or pd.products_description like '%gift%' or pd.short_desc like '%gift%') or (pd.products_name like '%lighter%' or p.products_model like '%lighter%' or p.products_shape like '%lighter%' or m.manufacturers_name like '%lighter%' or pd.products_description like '%lighter%' or pd.short_desc like '%lighter%') or (pd.products_name like '%case%' or p.products_model like '%case%' or p.products_shape like '%case%' or m.manufacturers_name like '%case%' or pd.products_description like '%case%' or pd.short_desc like '%case%') or (pd.products_name like '%hygrometer%' or p.products_model like '%hygrometer%' or p.products_shape like '%hygrometer%' or m.manufacturers_name like '%hygrometer%' or pd.products_description like '%hygrometer%' or pd.short_desc like '%hygrometer%') or (pd.products_name like '%cutter%' or p.products_model like '%cutter%' or p.products_shape like '%cutter%' or m.manufacturers_name like '%cutter%' or pd.products_description like '%cutter%' or pd.short_desc like '%cutter%') or (pd.products_name like '%ashtray%' or p.products_model like '%ashtray%' or p.products_shape like '%ashtray%' or m.manufacturers_name like '%ashtray%' or pd.products_description like '%ashtray%' or pd.short_desc like '%ashtray%') or (pd.products_name like '%sample%' or p.products_model like '%sample%' or p.products_shape like '%sample%' or m.manufacturers_name like '%sample%' or pd.products_description like '%sample%' or pd.short_desc like '%sample%') ) and (IF(s.status, s.specials_new_products_price, p.products_price) >= 50) and (IF(s.status, s.specials_new_products_price, p.products_price) <= 75) order by limit 0, 30
[TEP STOP]
| |
