select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_image, pa.options_values_price, pa.price_prefix, pa.products_options_sort_order from h2f_products_attributes pa, h2f_products_options_values pov where pa.products_id = '271' and pa.options_id = '16' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '4' order by pa.products_options_sort_order [TEP STOP] |
