SELECT att.`name_nl-NL` products_options,attval.`name_nl-NL` products_options_values,
SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 1),'i:',-1)  order_options_id

, SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 2),'i:',-1)  order_options_values_id
 from  <@PREFIX>jshopping_order_item
    join
 <@PREFIX>jshopping_attr att on att.attr_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 1),'i:',-1)
join
 <@PREFIX>jshopping_attr_values attval on attval.value_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 2),'i:',-1)


where order_id = <@ORDERS_ID@> and product_id = <@ORDERS_PRODUCTS_ID@> and
position('}' in SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 2),'i:',-1)) =0
 union
SELECT att.`name_nl-NL` products_options,attval.`name_nl-NL` products_options_values,
  SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 3),'i:',-1)  a

, SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 4),'i:',-1)  b
 from  <@PREFIX>jshopping_order_item  
    join
 <@PREFIX>jshopping_attr att on att.attr_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 3),'i:',-1)
join
 <@PREFIX>jshopping_attr_values attval on attval.value_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 3),'i:',-1)

where order_id = <@ORDERS_ID@> and product_id = <@ORDERS_PRODUCTS_ID@> and
position('}' in SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 4),'i:',-1)) =0

 union
SELECT att.`name_nl-NL` products_options,attval.`name_nl-NL` products_options_values,  SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 5),'i:',-1)  a

, SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 6),'i:',-1)  b
 from  <@PREFIX>jshopping_order_item
    join
 <@PREFIX>jshopping_attr att on att.attr_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 5),'i:',-1)
join
 <@PREFIX>jshopping_attr_values attval on attval.value_id = SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 6),'i:',-1)


where order_id = <@ORDERS_ID@> and product_id = <@ORDERS_PRODUCTS_ID@> and
position('}' in SUBSTRING_INDEX(SUBSTRING_INDEX(attributes, ';', 6),'i:',-1)) =0
