SET sql_mode = '';
SELECT
t1.sku as `product_sku`,
COUNT(t1.sku) as `integrity_check`,
NOT t2.sku IS NULL as `descriptive_detail`,
NOT t2.magento IS NULL as `descriptive_detail_updated`,
NOT t3.sku IS NULL as `collateral_detail`,
NOT t3.magento IS NULL as `collateral_detail_updated`,
NOT t4.sku IS NULL as `product_supplies`,
NOT t4.magento IS NULL as `product_supplies_updated`,
NOT t5.sku IS NULL as `publishing_details`,
NOT t5.magento IS NULL as `publishing_details_updated`,
NOT t6.sku IS NULL as `related_materials`,
NOT t6.magento IS NULL as `related_materials_updated`,
1 as `__filler`
FROM cbimport.products t1
LEFT JOIN `descriptive_details` t2 ON t1.sku = t2.sku AND t2.current = 1
LEFT JOIN `collateral_details` t3 ON t1.sku = t3.sku AND t3.current = 1
LEFT JOIN `product_supplies` t4 ON t1.sku = t4.sku AND t4.current = 1
LEFT JOIN `publishing_details` t5 ON t1.sku = t5.sku AND t5.current = 1
LEFT JOIN `related_materials` t6 ON t1.sku = t6.sku AND t6.current = 1
GROUP BY t1.sku

#HAVING `integrity_check` > 1


# checking the integrity of current for blocks. Should return 0 rows.
SELECT
products.sku as `product_sku`,
COUNT(products.sku) AS `integrity_check`
FROM `products`
LEFT JOIN `descriptive_details` dd ON products.sku = dd.sku AND dd.current = 1
LEFT JOIN `collateral_details` cd ON products.sku = cd.sku AND cd.current = 1
LEFT JOIN `product_supplies` ps ON products.sku = ps.sku AND ps.current = 1
LEFT JOIN `publishing_details` pd ON products.sku = pd.sku AND pd.current = 1
LEFT JOIN `related_materials` rm ON products.sku = rm.sku AND rm.current = 1
GROUP BY products.sku
HAVING integrity_check > 1
ORDER BY integrity_check DESC

Non integer sku
'5400644021099'