| 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.ID IN(474632,474633,474634,474635,474636,474637,474638,474639,474640,474641,474642,474643,474644,474645,474646,474647,474648,474649,474650,474651,474652,474653,474654,474655,474656,474657,474658,474659,474660,474661,474662,474663,474664,474665,474666,474669,474670,474671,474672,474673,474674,474675,474676,474677,474678,474679,474680,474681,474682,474683,474684,474685,474686,474687,474688,474689,474690,474691,474692,474693,474694,474695,474696,474697,474698,474699,474700,474701,474702,474703,474704,474705,474706,474707,474708,474709,474710,474711,474712,474713,474714,474715,474716,474717,474718,474719,474720,474721,474722,474723,474724,474725,474726,474727,474728,474729,474730,474731,474732,474733,474734,474735,474736,474737,474738,474739,474740,474741,474742,474743,474744,474745,474746,474747,474748,474749,474750,474751,474752,474753,474754,474755,474756,474757,474758,474759,474760,474761,474762,474763)
)
)
)
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.ID IN(474632,474633,474634,474635,474636,474637,474638,474639,474640,474641,474642,474643,474644,474645,474646,474647,474648,474649,474650,474651,474652,474653,474654,474655,474656,474657,474658,474659,474660,474661,474662,474663,474664,474665,474666,474669,474670,474671,474672,474673,474674,474675,474676,474677,474678,474679,474680,474681,474682,474683,474684,474685,474686,474687,474688,474689,474690,474691,474692,474693,474694,474695,474696,474697,474698,474699,474700,474701,474702,474703,474704,474705,474706,474707,474708,474709,474710,474711,474712,474713,474714,474715,474716,474717,474718,474719,474720,474721,474722,474723,474724,474725,474726,474727,474728,474729,474730,474731,474732,474733,474734,474735,474736,474737,474738,474739,474740,474741,474742,474743,474744,474745,474746,474747,474748,474749,474750,474751,474752,474753,474754,474755,474756,474757,474758,474759,474760,474761,474762,474763)
)
)
ORDER BY p.ManufacturerName,p.Text1,p.Name,p.ImageProgression |
