No go with the view ... same error:
DB=# SELECT products.id
FROM products
WHERE name ILIKE 'AA'
UNION
SELECT prod_id
FROM v_products_cast_crews
WHERE cast_crew=1012
ORDER BY products.id;
NOTICE: Adding missing FROM-clause entry for table "products"
ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
the result columns