| SQL |
SELECT ID,Name,PartNumber,RTrim(Text1) AS Text1,Boolean1,Boolean2,Image2,ImageID,AnimatedGif,CategoryKeywords,CategoryDescription,CategoryTitle,CategoryName,ManuKeywords,ManuDescription,ManufacturerID,ManufacturerName,ManuTitle,MSRP,('http://admin.helmetharbor.com/Images/StoreImages/2/' + CAST(p.ImageID AS varchar) + '_2.' + p.FileExt) AS Image,
CASE WHEN (p.MAP > 0 AND -1 = -1)
THEN Round(p.MAP,2)
WHEN (p.MAP > 0 AND p.MAP < p.Price1 * 1 AND p.MAP < p.Price1)
THEN Round(p.MAP,2)
WHEN p.Price1 * 1 > p.Price1
THEN Round(p.Price1,2)
ELSE Round((p.Price1 * 1),2)
END AS Price
FROM cecadmin.qry_Products2 p
WHERE 1 = 1
AND p.StoreID = 2
AND p.ImageProgression = 1
AND p.Active = 1
AND p.ImageActive = 1
AND (p.ID IN(
SELECT p.ID
FROM cecadmin.qry_Products2 p
WHERE 1 = 1
AND p.StoreID = 2
AND p.Active = 1
AND p.IP1 = 2 AND p.IP2 = 10 )
)
AND p.ManufacturerID IN (
SELECT p.ManufacturerID
FROM cecadmin.qry_Products2 p
WHERE 1 = 1
AND p.StoreID = 2
AND p.Active = 1
AND p.IP1 = 2 AND p.IP2 = 10 )
AND p.IP1 = 2 AND p.IP2 = 10
ORDER BY p.ManufacturerName,p.Text1,p.Name,p.ImageProgression |
