SELECT *, ROUND(((f.case_price * 2) + imp.imprint_cost), 2) AS new_price, IFNULL(8, 8) AS cost 
FROM (
    SELECT DISTINCT e.*, pis.warehouse_total_quantity AS new_stock, pis.case_price, apm4.meta_value AS impmethod 
    FROM (
        SELECT d.*, apm3.meta_value AS variation_description, SUBSTRING_INDEX(apm3.meta_value, ' - ', -1) AS unique_key 
        FROM (
            SELECT c.*, apm2.meta_value AS stock 
            FROM (
                SELECT b.*, apm.meta_value AS sku 
                FROM (
                    SELECT ap.* 
                    FROM zmws_posts ap 
                    WHERE ap.post_type = 'product_variation' 
                    AND ap.post_status = 'publish' 
                    AND ap.post_date > '2022-03-08 23:59:59' 
                    AND ap.ID NOT IN (
                        SELECT tr.object_id 
                        FROM zmws_term_relationships tr 
                        LEFT JOIN zmws_terms t ON tr.term_taxonomy_id = t.term_id 
                        WHERE t.name = 'Inventory'
                    ) 
                    ORDER BY ap.ID ASC
                ) b 
                LEFT JOIN zmws_postmeta apm ON apm.post_id = b.ID WHERE apm.meta_key = '_sku'
            ) c 
            LEFT JOIN zmws_postmeta apm2 ON apm2.post_id = c.ID WHERE apm2.meta_key = '_stock'
        ) d 
        LEFT JOIN zmws_postmeta apm3 ON apm3.post_id = d.ID WHERE apm3.meta_key = '_variation_description'
    ) e 
    LEFT JOIN zmws_sanmar_dip_product_inv_summed pis ON pis.unique_key = e.unique_key 
    LEFT JOIN zmws_postmeta apm4 ON apm4.post_id = e.ID WHERE apm4.meta_key = '_imprint_method'
) f 
LEFT JOIN zmws_imprint_methods imp ON imp.imprint_method = f.impmethod;