1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pa.options_id = popt.products_options_id AND pa.options_values_id = poval.pr' at line 1 in: [SELECT popt.products_options_id, popt.products_options_name, poval.products_options_values_id, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.attributes_price_factor FROM products_options popt, products_options_values poval, products_attributes pa WHERE pa.products_id = AND pa.options_id = popt.products_options_id AND pa.options_values_id = poval.products_options_values_id order by LPAD(popt.products_options_sort_order,11,"0"), LPAD(pa.products_options_sort_order,11,"0")]
|