I got kicked out while typing!
I have this query working, but only for one product id (52). I need to retrieve all data.
PHP Code:
select
p.products_id,
p.products_model,
pa.products_attributes_id,
pa.options_values_id,
pov.products_options_values_name,
sba.customid,
sba.quantity
from
zen_products as p
left join
zen_products_attributes as pa ON p.products_id = pa.products_id
left join
zen_products_with_attributes_stock as sba ON pa.products_attributes_id = sba.stock_attributes
left join
zen_products_options_values as pov ON pa.options_values_id = pov.products_options_values_id
where
p.products_id = 52;
This question might not belong here; but since it performs a query on the SBA table, I thought it could be OK?
Bookmarks