from GardenCenterMarketing.com

Query
Template: /products/qry_prodList.cfm:158
Execution Time: 3.44 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select p.udefIndexPageSequence, p.name, p.id, p.descripShrt, p.newUntil,
'' as purchaseDate,
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
p.udefCustomerSpecificProduct is null and
s.isactive and isnull(s.delete_date)
and lk.catID in ([CF_SQL_INTEGER])
group by s.prodID
order by p.udefIndexPageSequence asc, p.name, s.listPrice asc, s.sku, p.udefSunpatiensSequence, p.name

udefIndexPageSequence

name

descripShrt

newUntil

purchaseDate

primaryKeywords

secondaryKeywords

tertiaryKeywords

prodNavFriendly

udefNavFriendly

skuID

qty