SELECT 'products_image' org,concat('img_products/',  image_name)  image
  FROM <@PREFIX@>jshopping_products_images where ordering = 1 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage1' org, concat('img_products/',  image_name)  
 FROM <@PREFIX@>jshopping_products_images where ordering = 2 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage2' org,concat('img_products/',  image_name) 
 FROM <@PREFIX@>jshopping_products_images where ordering = 3 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage3' org,concat('img_products/',  image_name) 
 FROM <@PREFIX@>jshopping_products_images where ordering = 4 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage4' org,concat('img_products/',  image_name)
 FROM <@PREFIX@>jshopping_products_images where ordering = 5 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage5' org,concat('img_products/',  image_name)
 FROM <@PREFIX@>jshopping_products_images where ordering = 6 and product_id = <@PRODUCTS_ID@>
union
SELECT 'products_subimage6' org,concat('img_products/',  image_name)
 FROM <@PREFIX@>jshopping_products_images where ordering = 7 and product_id = <@PRODUCTS_ID@>