Smith V TI (Chrome, Polar Copper-Ignitor-Clear)

match: 2
temp pname: 2
cat sql: SELECT category_name, friendly_url FROM va_categories WHERE category_name LIKE '%Smith V TI%'

match: 1
temp pname: 1
sql: SELECT item_name, friendly_url FROM va_items WHERE item_name LIKE '%Smith V%' AND ( item_name LIKE '%prescription%' OR item_name LIKE '%rx%')