View Full Version : Recover missing order info from DB

10-22-2008, 08:00 AM
Some people may need products attributes information. Here is the MySQL code to do that. Substitute the actual customer's id for

SELECT cb.customers_basket_quantity, pd.products_name, pov.products_options_values_name
FROM customers_basket cb
JOIN products_description pd ON pd.products_id=cb.products_id
JOIN customers_basket_attributes cba ON cba.customers_id=cb.customers_id
JOIN products_options_values pov ON cba.products_options_value_id=pov.products_options _values_id
WHERE cb.customers_id =''
AND pd.language_id = '1'

More... (http://addons.oscommerce.com/info/4763)