Unknown column 'Array' in 'where clause' Query: CREATE TEMPORARY TABLE IF NOT EXISTS tmp_products ( SELECT products.* FROM products INNER JOIN finishes ON finishes.id = products.finish WHERE products.name != '' AND products.type='paint' AND (products.site='dp' OR products.site='both') AND products.status='approved' AND products.finish IN (SELECT finish_id FROM application_to_finish WHERE 1 AND application_id = Array) AND 1 ORDER BY finishes.displayorder, finishes.name LIMIT 1)