select p.products_id, p.options_quantity, po.products_options_name, pov.products_options_values_color_code, pov.products_options_values_name from products_attributes p, products_options po, products_options_values pov where p.options_id = po.products_options_id and p.options_values_id = pov.products_options_values_id and po.language_id = '1' and pov.language_id = '1' and products_id = '4908' order by pov.products_options_values_sorting