Anonymous
public text v1 · immutableSELECT COUNT(DISTINCT uploader_user_id) FROM op_media WHERE status='OK' AND event_id=149806492 AND uploader_user_id IN (SELECT user_id FROM op_user);
SELECT COUNT(DISTINCT uploader_user_id) FROM op_media, op_user WHERE status='OK' AND event_id=149806492 AND op_media.uploader_user_id = op_user.user_id;
SELECT COUNT(DISTINCT uploader_user_id) FROM op_media INNER JOIN op_user ON op_user.user_id=op_media.uploader_user_id WHERE status='OK' AND event_id=149806492;