SELECT
s.id,s.name,s.ua_name,s.ua_description,s.class_id,s.description,s.image,s.storage,s.i1,s.i2,s.i3,s.i4,s.special,s.price,s.vote,s.voters,c.name_cat FROM products s JOIN categories c ON c.id_cat=s.class_id WHERE (s.special = 'rec' ) ORDER BY s.id LIMIT 4