-- 'velvet only test'

SELECT
					p.product_uuid AS id,
					p.product_description,
                    p.category_uuid,
					p.spot_uv_sides_uuid,
					p.paper_coating_uuid,
					p.paper_stock_uuid,
					uv.spot_uv_sides_name,
					p.lamination_uuid,
					l.lamination_name,
					pb.colorspec AS color,
					pb.runsize AS qty,
					pb.product_baseprice AS transfer,
					pw.paper_lbs_per_square_inch_per_thousand,
					pb.turn_around,
					sc.paper_stock_coating_name,
					sc.paper_stock_coating_desc,
					sc.paper_stock_coating_code,
					x.sort_order,
					p.import_status
				FROM
					4over_product_setup_types_to_paper_stocks_coatings AS x
					LEFT JOIN 4over_paper_stocks_coatings AS sc ON sc.id = x.paper_stock_coating_id
					LEFT JOIN 4over_products AS p ON ( p.paper_stock_uuid = sc.paper_stock_uuid AND p.paper_coating_uuid = sc.paper_coating_uuid AND p.category_uuid = sc.category_uuid )
					LEFT JOIN 4over_products_base_prices AS pb ON pb.product_uuid = p.product_uuid
					LEFT JOIN 4over_paper_stocks AS ps ON ps.paper_stock_uuid = p.paper_stock_uuid
					LEFT JOIN 4over_product_weights AS pw ON pw.paper_stock_uuid = ps.paper_stock_uuid
					LEFT JOIN 4over_spot_uv_sides AS uv ON uv.spot_uv_sides_uuid = p.spot_uv_sides_uuid
					LEFT JOIN 4over_lamination AS l ON l.lamination_uuid = p.lamination_uuid
				WHERE
					x.product_setup_type = 'velvet only test'
					AND ( p.sheet_size = '6x9' OR p.sheet_size = '9x6' )
					AND pb.colorspec IN ('4/4')
					AND ( pb.runsize >= 500 AND pb.runsize <= 2500 )
					AND p.import_status != -1
					AND ( ( p.lamination_uuid = sc.lamination_uuid OR p.lamination_uuid = '' OR p.lamination_uuid IS NULL ) )
				ORDER BY
					sort_order ASC, qty ASC, spot_uv_sides_uuid DESC