SELECT
  pa.lat
FROM
  context AS c 
  JOIN pseudoana AS pa ON c.id_ana = pa.id 
  JOIN data AS d ON d.id_context=c.id 
WHERE
  c.id_report=1 AND 
  c.datetime >= '1001-01-01 00:00:00' 
ORDER BY  c.id_ana, c.datetime, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2;
;


SELECT
  pa.lat
FROM
  context AS c 
  JOIN pseudoana AS pa ON c.id_ana = pa.id 
  JOIN data AS d ON d.id_context=c.id 
WHERE
  c.id_report=1 AND 
  c.datetime >= '1001-01-01 00:00:00' 
;