select distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock, patrib.products_options_sort_order from h2f_products_options popt, h2f_products_attributes patrib where patrib.products_id='1687' and patrib.options_id = popt.products_options_id and popt.language_id = '4' order by patrib.products_options_sort_order [TEP STOP] |
