Error: select id as id, id as cId, nombre_es as nombre_es, nombre_en as nombre_en, nombre_fr as nombre_fr, nombre_eu as nombre_eu, active as active from trabajos_categorias where active and (select count(*) from trabajos where categoria_id = cId) order by nombre_es asc

Unknown column 'cId' in 'where clause'