Cuban Cigar Products Directory featuring Cuban cigars from Canada like Cohiba Montecristo H Upmann Bolivar Romeo y Julieta Hoyo de Monterrey Vegas Robaina Trinidad Robustos Churchills Corona Torpedo Habana Hananos Havana Belinda Cabanas Cuaba Diplomaticos Fonseca Guantenamera Juan Lopez Jose Piedra J Cano La Flor del Cana Partagas Quai Dorsay Ramon Allones Rey del Mundo Saint Luis Rey San Cristobal Statos Sancho Panza Troya
SELECT ca.SectionName, CatDesc=ca.Description, CatImage=ca.Image,
pr.ProductName, pr.PriceDesc, ProdDesc=pr.Description, ShortDesc=pr.ShortDesc,
pr.Price, pr.Image, pr.OnSale, pr.SalePrice, pr.New
FROM Prodcats pc, Sections ca, Products pr
WHERE pr.ProductCode = '#ProductCode#'
AND pc.PC_CategoryID = ca.SectionID
AND pc.PC_ProductID = pr.ProductID
AND ca.Status = 0 AND pr.Status = 0
AND ca.Deleted <> 1 AND pr.Deleted <> 1
ORDER BY ca.Sequence, pc.Sequence
SELECT FT_FeatureName, FT_Sequence
FROM Features, FeatureValues
WHERE FT_ProductCode = '#ProductCode#'
AND FT_ProductCode = FV_ProductCode
AND FT_FeatureName = FV_FeatureName
GROUP BY FT_FeatureName, FT_Sequence
ORDER BY FT_Sequence
SELECT *
FROM Features
WHERE FT_Productcode = '#ProductCode#'
AND FT_FeatureName <> 'Quantity'
ORDER BY FT_Sequence
SELECT *
FROM FeatureValues
WHERE FV_Productcode = '#ProductCode#'
AND FV_FeatureName = 'Quantity'
ORDER BY FV_Sequence
