0
Query
Template: /products/qry_prodList.cfm:158
Execution Time: 4.44 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select p.udefIndexPageSequence, p.name, p.id, p.descripShrt, p.newUntil,
MATCH (p.name,p.primaryKeywords,p.descripShrt) AGAINST ('image/image/favicon.gif' IN NATURAL LANGUAGE MODE) as score,
'' 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
MATCH (p.name,p.primaryKeywords,p.descripShrt) AGAINST ('image/image/favicon.gif' IN NATURAL LANGUAGE MODE) > 0 and
p.udefPublicProduct = 1 and
p.udefCustomerSpecificProduct is null and
s.isactive and isnull(s.delete_date)
group by s.prodID
order by score desc, p.udefIndexPageSequence asc, p.name, s.listPrice asc, s.sku, p.udefSunpatiensSequence, p.name
udefIndexPageSequencenameiddescripShrtnewUntilscorepurchaseDateprimaryKeywordssecondaryKeywordstertiaryKeywordsprodNavFriendlyudefNavFriendlyskuIDqtyqtyUnitcatNavFriendlyudefActiveSkusudefPosterPrintedSidesudefPosterMaterialudefPosterSizeudefStartingAtudefOnSaleudefFeatherPrintedSidesudefFeatherBaseudefFeatherSizeudefPoleSleeveudefQuickShipcatName

Sorry, no results matched your search

Perhaps try another keyword, or simplifying your search term(s).

Product Search


Plant Search


Still no luck?

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

  FILTERS