PIEROMACCCCCC
ho un grosso problema
ho una query che ha funzionato per quasi un anno!
oggi è stato fatto un inserimento e ha dato un estrazione sballata
e nn mi spiego il perchè
Codice PHP:
SELECT DISTINCT au.id_A,au.autore,au.dir,
COUNT(ca.id_F) as ca,
GROUP_CONCAT(DISTINCT cl.titolo ORDER BY cl.id_F DESC ) AS cl_ti,
GROUP_CONCAT(DISTINCT cl.id_F ORDER BY cl.id_F DESC ) AS cl,
GROUP_CONCAT(DISTINCT es.titolo ORDER BY es.id_F DESC ) AS es_ti,
GROUP_CONCAT(DISTINCT es.id_F ORDER BY es.id_F DESC ) AS es,
GROUP_CONCAT(DISTINCT fi.titolo ORDER BY fi.id_F DESC ) AS fi_ti,
GROUP_CONCAT(DISTINCT fi.id_F ORDER BY fi.id_F DESC ) AS fi
FROM in_autori as au
LEFT JOIN in_fiabe as fi ON au.id_A = fi.id_A
LEFT JOIN in_cartoline as ca ON au.id_A = ca.id_A
LEFT JOIN in_classici as cl ON au.id_A = cl.id_A
LEFT JOIN in_esperimenti as es ON au.id_A = es.id_A
GROUP BY au.id_A
ORDER BY au.id_A DESC
il conteggio -> COUNT(ca.id_F) as ca ->è sballato
tu mi sai dire in cosa sbaglio?