Savings's Predictions and Promises
SELECT count( DISTINCT f1.entity_id ) as total FROM `field_data_field_tags` f1, `taxonomy_term_data` f2, `field_data_field_result` fdfr, `field_data_field_tags` tags, `field_data_field_featured` featured where fdfr.field_result_value IN ('Proved False', 'Came True') and fdfr.bundle = 'public_prediction' and f1.entity_id = fdfr.entity_id and tags.field_tags_tid = 2925 and tags.entity_id = fdfr.entity_id and featured.field_featured_value like 'Feature this post' and featured.entity_id = fdfr.entity_id

Savings's Predictions and Promises