Could not obtain data information SELECT a.id_plan, a.anno, a.lmm, a.lmnth, a.mmnth, a._mmnth, a.lmnth - a.mmnth as t1, b.lmm AS b_lmm, b.lmnth AS b_lmnth, b.mmnth AS b_mmnth, b._mmnth AS b__mmnth, b.lmnth - b.mmnth as t2, c.comune, c.seriale, d.tg FROM _graphics AS a LEFT JOIN __georese AS b ON ( b.id_plan = a.id_plan AND b.anno = a.anno) LEFT JOIN plan AS c ON ( c.uid = a.id_plan ) LEFT JOIN provincie AS d ON d.id_p = c.id_p WHERE a.flg IS NULL AND b.flg > 0 AND (a.lmnth IS NOT NULL or b.lmnth IS NOT NULL ) ORDER BY a.anno DESC, a.lmm DESC |