questa è la query a video:

codice:
SELECT * FROM ads WHERE AD_POSTER IN (SELECT C_USERS FROM CAP WHERE C_CAP = '67039' OR C_CAP = '67038' OR C_CAP = '67037' OR C_CAP = '67036' OR C_CAP = '67035' OR C_CAP = '67034' OR C_CAP = '67040' OR C_CAP = '67040' OR C_CAP = '67041' OR C_CAP = ' 67043' OR C_CAP = '67044' ) AND ABILITATO = 1 AND AD_EXPIRED >= date() AND AD_TYPE = '36' ORDER BY C_USERS ASC
... ma la parentesi di chiusura va bene lì?