Could not obtain data information SELECT a.*, b.tg, b.provincia, b.kwh, c.regione, d.anno AS lastyear FROM plan AS a LEFT JOIN provincie AS b ON ( b.id_p = a.id_p ) LEFT JOIN regioni AS c ON ( c.id_r = b.id_r ) LEFT JOIN rese AS d ON ( d.id_plan = a.uid AND d.anno = '2013' ) WHERE a.uid = '145' AND d.anno = '2013' ORDER BY b.provincia ASC LIMIT 1