Selecting Consective rows with same Value & calcute the difference between timestamps of same value rows.Please Check What will b error in this query?
Right before 

) AS t2


is 

 ORDER BY  MSISDN,times


which does not make sense.  If times is to be a table, then it should not be JOINed (with a comma) to another table with an ORDER BY clause.  (Unless you put parens around the subquery.)

Or was that supposed to be a period, not a comma?:  MSISDN.times

When Error 1064 says "near", it means it.