TEST:
SELECT a.ACODAR, a.ADESCR, a.APVP1, a.APVP2, a.APVP3, a.APVP4, a.ARESNUM5, a.ARESNUM6, a.ATIPO, a.ATIPO2, a.AFAMILIA, s.ASTOCK, fil.fil1, fil.fil2, fil.fil3, fil.fil4, fil.fil5, fil.fil6, fil.fil7, fil.fil8, fil.fil9, fil.fil10, fil.fil11, fil.fil12, a.AINT01, a.AINT02, a.AINT03, a.AINT04, a.AINT05, a.AINT06, a.AINT07, a.AINT08, a.AINT09, a.AINT10, a.AINT11, a.AINT12, a.AINT13, a.AINT14, a.AINT15, a.AINT16, a.AINT17, a.AINT18, a.AINT19, a.AINT20
FROM fcart AS a, fcstk AS s, filtroart AS fil
WHERE a.ACODAR = s.ACODAR
AND a.ACODAR = fil.ACODAR
AND s.AALM = 1
AND s.ASTOCK > 0
AND a.ABLOQUEADO = 'N'
AND (a.APVP1 > 0 AND a.APVP2 > 0 AND a.APVP3 > 0 AND a.APVP4 > 0 )
AND a.ARESSN2 = 'N'
AND a.AFAMILIA BETWEEN 100 AND 572
AND a.ARESNUM4 BETWEEN 1 AND 9999
AND a.ARESNUM4 <> 1450
AND fil.id_categoria = 0 ORDER BY RAND() ASC
