";
$SQL = "SELECT T1.*, T2.cca_ordre
FROM cst_colles_castell T1
LEFT JOIN cst_cat_castells T2 on T1.ccc_castell = T2.id_castell
WHERE ccc_colla = '$ID_COLLA' AND ccc_estat IS NOT NULL AND ccc_estat <> ''
ORDER BY CASE
WHEN (ccc_dDATA IS NOT NULL AND ccc_dDATA <> '0000-00-00') THEN ccc_dDATA
WHEN (ccc_cDATA IS NOT NULL AND ccc_cDATA <> '0000-00-00') THEN ccc_cDATA
WHEN (ccc_idDATA IS NOT NULL AND ccc_idDATA <> '0000-00-00') THEN ccc_idDATA
ELSE ccc_iDATA
END";
// LEFT JOIN CST_COLLES ON CST_COLLES_CASTELL.CCC_COLLA = CST_COLLES.ID_COLLA
$cst_result = mysqli_query($link,$SQL) or die("Error: $SQL!");
if (mysqli_num_rows($cst_result)) {
while ($cst_row = @mysqli_fetch_array($cst_result)) {
$ccc_dDATA = ($cst_row["ccc_dDATA"]=="0000-00-00")?"":cstDataCat($cst_row["ccc_dDATA"]);
$ccc_dPOBL = $cst_row["ccc_dPOBL"];
$ccc_dMOTI = $cst_row["ccc_dMOTI"];
$ccc_cDATA = ($cst_row["ccc_cDATA"]=="0000-00-00")?"":cstDataCat($cst_row["ccc_cDATA"]);
$ccc_cPOBL = $cst_row["ccc_cPOBL"];
$ccc_cMOTI = $cst_row["ccc_cMOTI"];
$ccc_iDATA = ($cst_row["ccc_iDATA"]=="0000-00-00")?"":cstDataCat($cst_row["ccc_iDATA"]);
$ccc_iPOBL = $cst_row["ccc_iPOBL"];
$ccc_iMOTI = $cst_row["ccc_iMOTI"];
if (($ccc_iDATA!="") || (($ccc_iPOBL!="") && ($ccc_iPOBL!="-"))) {
$ccc_iTIPUS = ($cst_row["ccc_iTIPUS"]=="i")?"Intent":"Intent Desmuntat";
} else {
$ccc_iTIPUS = "";
}
$ccc_ESTAT = $cst_row["ccc_estat"];
$ccc_OBS = $cst_row["ccc_OBS"];
echo "