|
| Home :: Advanced Search :: Search Results |
Advanced Search |
select
p.products_id,
p.products_tax_class_id,
IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price,
p.products_sort_order ,
pme.artists_id as artists_id ,
a.albums_id as albums_id,
ra.artists_name as artists_name,
pme.average_review as average_review,
pme.ages as ages
from (z_products p, z_products_description pd, z_b_product_music_extra pme, z_b_record_artists ra
left join z_b_albums a on a.albums_id = pme.albums_id)
LEFT JOIN z_specials s on p.products_id = s.products_id
where
p.products_id = pd.products_id and
p.products_id = pme.products_id and
pme.artists_id = ra.artists_id and ((pd.products_name like '%canon%' or p.products_model like '%canon%' or pd.products_description like '%canon%') )
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 'select
p.products_id,
p.products_tax_class_id,
if(s.status
| |
