SELECT po.product_option_id,po.sort_order,po.addon,po.pim_option_dropdown,po.product_change FROM product_option po LEFT JOIN product p ON (po.product_id = p.product_id) WHERE product_id = '4000' AND p.stock_status_id ='7'  ORDER BY po.sort_order