select id,date,customerid, consumption,yearmonth_customerid_customers_customerid from /birddata/yearmonth where customerid=7653 and date like '2012*' /** output() **/ ;