trabulium · March 16, 2018 00:59
diff --git a/Find product_stock_alerts in last 12 months b/Find product_stock_alerts in last 12 months
 select email, customer_id, product_id, sku, cpev.value, add_date from product_alert_stock  as pas
 left join catalog_product_entity as cpe on pas.product_id = cpe.entity_id
 left join catalog_product_entity_varchar as cpev on cpev.`entity_id` = cpe.entity_id
 where add_date > '2017-03-16 00:00:00' 
 and send_date is NULL
 and cpev.attribute_id = 71
 order by cpev.value;
	select email, customer_id, product_id, sku, cpev.value, add_date from product_alert_stock as pas
	left join catalog_product_entity as cpe on pas.product_id = cpe.entity_id
	left join catalog_product_entity_varchar as cpev on cpev.`entity_id` = cpe.entity_id
	where add_date > '2017-03-16 00:00:00'
	and send_date is NULL
	and cpev.attribute_id = 71
	order by cpev.value;