Error: SELECT ccc_castell, ccc_estat
FROM cst_colles_castell
LEFT JOIN cst_cat_castells ON cst_colles_castell.ccc_castell = cst_cat_castells.id_castell
WHERE cst_colles_castell.ccc_colla = '48'
AND (ccc_estat='d' OR ccc_estat='c')
ORDER BY cca_ordre DESC!