|
| 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 '%o%' or p.products_model like '%o%' or pd.products_description like '%o%') and (pd.products_name like '%where%' or p.products_model like '%where%' or pd.products_description like '%where%') and (pd.products_name like '%have%' or p.products_model like '%have%' or pd.products_description like '%have%') and (pd.products_name like '%you%' or p.products_model like '%you%' or pd.products_description like '%you%') and (pd.products_name like '%been%' or p.products_model like '%been%' or pd.products_description like '%been%') and (pd.products_name like '%billy%' or p.products_model like '%billy%' or pd.products_description like '%billy%') and (pd.products_name like '%boy%' or p.products_model like '%boy%' or pd.products_description like '%boy%') and (pd.products_name like '%billy%' or p.products_model like '%billy%' or pd.products_description like '%billy%') and (pd.products_name like '%boy%' or p.products_model like '%boy%' or pd.products_description like '%boy%') )
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
| |
