SELECT A.* , R.symbol
FROM act_base_asortyment as A left join act_base_firmy as R on A.firma = R.id
WHERE (A.menu_id = '1043' OR (A.mcat20 & 1)) AND (A.foto != '' AND R.xstatus = 2) AND A.status = 1 AND (A.perms & 1) AND A.date_end >= NOW() AND A.date_start <= NOW() AND A.lang & 1
ORDER BY rand()
LIMIT 32
