A
Size: a a a
A
A
MM
A
A
MM
A
A
R#
R#
MF
D
A
A
M
M
SELECT COUNT( DISTINCT t2.parsed_at )
FROM TABLE1 t1
LEFT JOIN TABLE2 t2 ON t2.id = t1.id AND t2.parsed_at >= '2020-05-01' AND t2.parsed_at <= '2020-05-25'
WHERE t1.zid = 1 AND t1.zsize = '40' AND t2.q > 0
M
A
M