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

• Adobe Stone 
• Boulder 
• Brighton 
• Cambridge 
• Camden 
• Derby 
• Devan 
• Domain 
• Halden 
• Hathaway 
• Highlander 
• Innsbruck 
• Lancaster 
• Montana 
• Parkhill 
• Pavilion 
• Portia 
• Rapture 
• RigidLock Plus WPC  
• RigidLock WPC 
• RockLock Plus 
• Sherbrooke 
• Timeless Traditions 
• Touch of Comfort 
• Trenton 
• Upton 
• UpTown Flare 
• WISE 
• Wood Classic 
• Ivory Coast 
• Pacific 
• Tuscan Coast