Size

sql: select col1, col1_name, col2_name, col3_name, col4_name, col5_name , min(product_options_adv_line.id) as id, pid, price_opt_normal, price_opt_disc1, price_opt_cross from product_options_adv_line inner join product_options_adv_header on product_options_adv_line.hid=product_options_adv_header.id where product_options_adv_header.pid=48549 group by col1, col1_name, col2_name, col3_name, col4_name, col5_name, pid, product_options_adv_line.id, price_opt_normal, price_opt_disc1, price_opt_cross

Quantity

1 2 3 4 5