| Query Template: /products/qry_prodList.cfm:158 Execution Time: 99.7 ms Record Count: 0 Cached: No Lazy: No SQL: select ( (MATCH(p.primaryKeywords) AGAINST ('image/image/favicon.jpg' IN BOOLEAN MODE)) + IF(p.primaryKeywords LIKE '%image/image/favicon.jpg%', 1, 0) ) as score, ( (MATCH(p.secondaryKeywords) AGAINST ('image/image/favicon.jpg' IN BOOLEAN MODE)) + IF(p.secondaryKeywords LIKE '%image/image/favicon.jpg%', 1, 0) ) as score2, ( (MATCH(p.tertiaryKeywords) AGAINST ('image/image/favicon.jpg' IN BOOLEAN MODE)) + IF(p.tertiaryKeywords LIKE '%image/image/favicon.jpg%', 1, 0) ) as score3, 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 ( MATCH (p.primaryKeywords,p.secondaryKeywords,p.tertiaryKeywords) AGAINST ('image/image/favicon.jpg' IN BOOLEAN MODE) OR p.primaryKeywords LIKE '%image/image/favicon.jpg%' OR p.secondaryKeywords LIKE '%image/image/favicon.jpg%' OR p.tertiaryKeywords LIKE '%image/image/favicon.jpg%' ) and p.udefPublicProduct = 1 and p.udefCustomerSpecificProduct is null and s.isactive and isnull(s.delete_date) group by s.prodID having score > 0 or score2 > 0 or score3 > 0 order by score desc, score2 desc, score3 desc, p.udefIndexPageSequence asc, p.name, s.listPrice asc, s.sku, p.udefSunpatiensSequence, p.name | |||||||||||||||||||||||||||||||
| score | score2 | score3 | udefIndexPageSequence | name | id | descripShrt | newUntil | purchaseDate | primaryKeywords | secondaryKeywords | tertiaryKeywords | prodNavFriendly | udefNavFriendly | skuID | qty | qtyUnit | catNavFriendly | udefActiveSkus | udefPosterPrintedSides | udefPosterMaterial | udefPosterSize | udefStartingAt | udefOnSale | udefFeatherPrintedSides | udefFeatherBase | udefFeatherSize | udefPoleSleeve | udefQuickShip | catName | ||
Sorry, no results matched your search
Perhaps try another keyword, or simplifying your search term(s).
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.