SELECT *
FROM products
WHERE Trim(category) = '#Trim(form.category)#'
ORDER BY category,productID
SELECT *
FROM products
WHERE ID <> 0
AND Trim(category) LIKE '#url.alphaletter#%'
AND (productID LIKE '%#first#%' OR category LIKE '%#first#%' OR description LIKE '%#first#%' OR size LIKE '%#first#%' OR price LIKE '%#first#%')
AND (productID LIKE '%#second#%' OR category LIKE '%#second#%' OR description LIKE '%#second#%' OR size LIKE '%#second#%' OR price LIKE '%#second#%')
AND (productID LIKE '%#third#%' OR category LIKE '%#third#%' OR description LIKE '%#third#%' OR size LIKE '%#third#%' OR price LIKE '%#third#%')
ORDER BY category,productID
Your search produced
#getSearchResults.recordCount#
listings