SELECT 
pr.attribute,
pr.product_weight
,pr.product_availability 
,IF(pr.product_special='Y',1,0) product_special 
,product_packaging
FROM <@PREFIX@>vm_product pr where pr.product_id = <@KEY@> 

