Array
(
    [0] => SELECT 
                p.id AS product_id,
                p.name AS product_name,
                pv.id AS product_variant_id,
                pv.measurement AS measurement,
                u.name AS unit_name,
                u.short_code,
                vp.vp_potency_name AS potency,
                p.*,
                vp.*
            FROM 
                products p
            LEFT JOIN 
                product_variant pv ON p.id = pv.product_id
            LEFT JOIN 
                unit u ON pv.measurement_unit_id = u.id
            LEFT JOIN 
                variant_potencies vp ON pv.id = vp.vp_v_id  WHERE p.status = 1  AND p.standard_shipping=0
)