SELECT p.product_id, p.is_archive, p.price_start FROM #__promart_search_indexer p WHERE p.published = 1 AND (p.not_searchable='0' OR p.not_searchable IS NULL) AND FIND_IN_SET("pencil sharpners",p.product_index) ORDER BY p.product_order = 0, p.product_order ASC, p.price_start ASC

---

Filter

Checking Totals...

The Currently Selected Options will Yield 1 Results... Show Me!

Oh No! The Currently Selected Options will Yield No Results...

Please Select Some Options Using the Filters to Display Products

GOMA2 - Sharpener and eraser

from £ 0.42 0.42