standard

SELECT itemid, name, slug, desc, spec
FROM product
WHERE specification MATCH 'pale red NEAR/1 color vans NEAR/1 brand us9 NEAR/1 size'
LIMIT 1 OFFSET 0