SELECT		bagco_order_product_print_method.print_method_id 				AS 'PrintMethodID',
			bagco_order_product.product_id									AS 'ProductID',
			bagco_order_product_print_method_print_line.logo_number			AS 'LogoNumber',
			bagco_order_product_print_method_print_line.quantity			AS 'Quantity',
			bagco_order_product_print_method_print_line.print_charge		AS 'PrintCharge',
			bagco_order_product_print_method_print_line.total_print_charge	AS 'TotalPrintCharge',
			IF(
				LENGTH( bagco_order.repeat_order_id ) > 0,
				CONCAT( 'Repeat Screen - ', bagco_order.repeat_order_id ),
				''
			  )																AS 'RepeatOrderID',
			bagco_order_product_print_method_print_line.setup_charge		AS 'SetupCharge',
			CASE IFNULL( bagco_order_product.express_charge, 0 )
				WHEN 30 THEN '3 Day Delivery'
				WHEN 50 THEN '2 Day Delivery'
				ELSE 'Express Delivery'
			END 															AS 'ExpressOption',
			bagco_order_product.express_charge								AS 'ExpressCharge'
FROM		bagco_order_product
LEFT JOIN	bagco_order									ON bagco_order.bagco_order_id = bagco_order_product.bagco_order_id
LEFT JOIN 	bagco_order_product_print_method 			ON bagco_order_product_print_method.bagco_order_product_id = bagco_order_product.bagco_order_product_id
LEFT JOIN 	bagco_order_product_print_method_print_line ON bagco_order_product_print_method_print_line.bagco_order_product_print_method_id =
														   bagco_order_product_print_method.bagco_order_product_print_method_id
WHERE		bagco_order_product.bagco_order_id = {{{BagcoOrderID}}}