
64+(2* 2 * 2 * 2 * 2 * 2 * 2048)+(2* 2 * 2 * 2 * 2 * 2 * 2 * 2048) + (2* 2 * 2 * 2 * 2 * 2 * 2 * 2 *2048)+1024




SELECT actual_number_of_occurrences, my_instance.instance_count, sms_recurrence.id
FROM  sms_recurrence, smsevent_sub1,
 ( 	SELECT count(sms_event_instance.id)  AS instance_count, sms_event_instance.parent_id FROM sms_event_instance, smsevent_sub1 AS sr2
 	WHERE sms_event_instance.parent_id=sr2.id_sub1 AND sr2.nenki='201501' AND  (sms_event_instance.status & 918592) = 0
 	GROUP BY sms_event_instance.parent_id
 ) AS my_instance
WHERE smsevent_sub1.id_sub1=sms_recurrence.id AND my_instance.parent_id=smsevent_sub1.id_sub1 
	AND my_instance.instance_count!=actual_number_of_occurrences

	

SELECT actual_number_of_occurrences, my_instance.instance_count, sms_recurrence.id
FROM  sms_recurrence, smsevent_sub1,
 ( 	SELECT count(sms_event_instance.id)  AS instance_count, sms_event_instance.parent_id FROM sms_event_instance, smsevent_sub1 AS sr2
 	WHERE sms_event_instance.parent_id=sr2.id_sub1 AND sr2.nenki='201410' AND  (sms_event_instance.status & 918592) = 0
 	GROUP BY sms_event_instance.parent_id
 ) AS my_instance
WHERE smsevent_sub1.id_sub1=sms_recurrence.id AND my_instance.parent_id=smsevent_sub1.id_sub1 
	AND my_instance.instance_count!=actual_number_of_occurrences