Query
Template: /products/qry_prodList.cfm:124
Execution Time: 7.97 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select p.udefIndexPageSequence, p.name, p.id, p.descripShrt, p.newUntil,
p.primaryKeywords,
p.secondaryKeywords,
p.tertiaryKeywords,
p.udefNavFriendly as prodNavFriendly,
p.udefNavFriendly as udefNavFriendly,
s.id as skuID,
s.qty, s.qtyUnit,
lu.udefNavFriendly as catNavFriendly,
p.udefActiveSkus,
p.udefPosterPrintedSides,
p.udefPosterMaterial,
p.udefPosterSize,
p.udefStartingAt,
p.udefOnSale,
p.udefFeatherPrintedSides,
p.udefFeatherBase,
p.udefFeatherSize,
p.udefPoleSleeve,
p.udefQuickShip,
lu.name as catName
from
tb_prods_skus s
inner join tb_prods p on (p.id = s.prodID)
left outer join tb_prods_cats_lk lk on (lk.prodID = p.id)
left outer join tb_prods_cats_lu lu on (lk.catID = lu.id)
where p.isactive and isnull(p.delete_date) and
p.udefPublicProduct = 1 and
s.isactive and isnull(s.delete_date) and
p.udefCustomerSpecificProductID is null
and lk.catID = 13
group by s.prodID
order by p.udefIndexPageSequence asc, p.name, s.listPrice asc, s.sku, p.udefSunpatiensSequence, p.name
udefIndexPageSequencenameiddescripShrtnewUntilprimaryKeywordssecondaryKeywordstertiaryKeywordsprodNavFriendlyudefNavFriendlyskuIDqtyqtyUnitcatNavFriendlyudefActiveSkusudefPosterPrintedSidesudefPosterMaterialudefPosterSizeudefStartingAtudefOnSaleudefFeatherPrintedSidesudefFeatherBaseudefFeatherSizeudefPoleSleeveudefQuickShipcatName

Looking for something in particular?

Sorry, your filter selections yielded no results. Feel free to contact us, and we'll be glad to assist you in any we can. Thanks again for visiting!