Офломелид мазь д/наруж примен 100г

select (CASE med.name WHEN "Неизвестный товар" THEN cat_items.title ELSE med.name END) AS this_title, cat_items.*, med_vendors.title as med_vendors_title, med_stores.title as med_stores_title, med.analog_id as med_analog_id, med.image from `gedeon_cat_items` as cat_items
LEFT JOIN `gedeon_med` as med ON med.id=cat_items.med_id
LEFT JOIN `gedeon_med_vendors` as med_vendors ON med_vendors.id=med.vendor_id
LEFT JOIN `gedeon_med_stores` as med_stores ON med_stores.id=cat_items.store_id
WHERE cat_items.avaliable>0 and med.cat_id="702001" and cat_items.id!="32366"
ORDER BY cat_items.views DESC
LIMIT 0,8