Inventory | Abraham Linc | Distributor of Quality Flooring Products

SELECT * FROM (SELECT * FROM (
					SELECT * FROM (
					SELECT * FROM items_view WHERE thumbnail != ''
					UNION
					SELECT * FROM items_view WHERE thumbnail = ''
				) tmp WHERE id > 0 AND LCASE(category) = 'resilient' AND (LCASE(product_type) = 'rocklock plus' OR LCASE(product_type) = 'lvt' OR LCASE(product_type) = 'sheet vinyl' OR LCASE(product_type) = 'rigid/wpc')AND LCASE(subcollection) != 'vista' AND LCASE(subcollection) != 'ridgeline' 
				GROUP BY subcollection) tmp WHERE thumbnail != ''

				UNION

				SELECT * FROM (
				SELECT * FROM (
					SELECT * FROM items_view WHERE thumbnail != ''
					UNION
					SELECT * FROM items_view WHERE thumbnail = ''
				) tmp WHERE id > 0 AND LCASE(category) = 'resilient' AND (LCASE(product_type) = 'rocklock plus' OR LCASE(product_type) = 'lvt' OR LCASE(product_type) = 'sheet vinyl' OR LCASE(product_type) = 'rigid/wpc')AND LCASE(subcollection) != 'vista' AND LCASE(subcollection) != 'ridgeline' 
				GROUP BY subcollection) tmp2 WHERE thumbnail = '') result LIMIT 120 OFFSET 0
Resilient
