Create Great Signage This Spring
Spring is right around the corner, but you still have time to create signage to help your customers get just the right plants.
Query Template: /products/qry_prodList.cfm:158 Execution Time: 5 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 p.udefCustomerSpecificProduct is null and s.isactive and isnull(s.delete_date) and lk.catID = 60 group by s.prodID order by p.udefIndexPageSequence asc, p.name, s.listPrice asc, s.sku, p.udefSunpatiensSequence, p.name | |||||||||||||||||||||||||||
udefIndexPageSequence | name | id | descripShrt | newUntil | primaryKeywords | secondaryKeywords | tertiaryKeywords | prodNavFriendly | udefNavFriendly | skuID | qty | qtyUnit | catNavFriendly | udefActiveSkus | udefPosterPrintedSides | udefPosterMaterial | udefPosterSize | udefStartingAt | udefOnSale | udefFeatherPrintedSides | udefFeatherBase | udefFeatherSize | udefPoleSleeve | udefQuickShip | catName |