Re: crosstab query?

[laptop alias]

SELECT u.*
     , y.*
  FROM user u
  LEFT
  JOIN
     (          
       SELECT user_id
            , MAX(CASE WHEN rank = 1 THEN data_date END) date1
            , MAX(CASE WHEN rank = 2 THEN data_date END) date2
            , MAX(CASE WHEN rank = 3 THEN data_date END) date3
         FROM 
            (
              SELECT t1.*
                   , COUNT(*) rank 
                FROM tbl_data t1
                JOIN tbl_data t2 
                  ON t1.user_id = t2.user_id
                 AND t1.data_date >= t2.data_date
               GROUP 
                  BY t1.data_date
            ) x 
        GROUP 
           BY user_id
     ) y
    ON y.user_id = x.user_id;