Sorry, we don't have any items in this category right now. Please check back later. Reset Filters
SELECT inventory_items.*, inventory_items.id AS inventory_id, inventory_categories.name AS category_name FROM inventory_items JOIN inventory_category_item ON (inventory_category_item.item_id = inventory_items.id) JOIN inventory_categories ON (inventory_categories.id = inventory_category_item.category_id) WHERE ( show_item = 1 ) AND ( inventory_categories.name LIKE '%big20sky%' OR inventory_items.name LIKE '%big20sky%' OR sku LIKE '%big20sky%' OR brand LIKE '%big20sky%' OR inventory_items.description LIKE '%big20sky%' OR features LIKE '%big20sky%' OR specs LIKE '%big20sky%' ) GROUP BY inventory_items.name ORDER BY stock_status ASC
