SELECT p.product_id , poi.product_code , pov.modifier as price , pov.modifier as list_price , pov.option_id , pov.variant_id , p.status , p.tracking
FROM cscart_products p
JOIN cscart_product_options_inventory poi ON poi.product_id = p.product_id
JOIN cscart_product_option_variants pov ON (pov.option_id = SUBSTRING_INDEX(poi.combination, '_', 1) AND pov.variant_id = SUBSTRING_INDEX(poi.combination, '_', -1))
WHERE p.tracking = "O"