Appion

Since stack, especially a substack does not contain the same particles as in the picking run, their coordinates are useful to have for those want to get off appion.

Here is the mysql script. You need to run this at the appiondb the intended project is in. 59 is the stackid (`DEF_id` field of ApStackData).

SELECT p.xcoord as x_coord, p.ycoord as y_coord, a.filename as image_name FROM `ApParticleData` p left join `ApStackParticleData` sp
on p.`DEF_id` = sp.`REF|ApParticleData|particle`
left join dbemdata.`AcquisitionImageData` a on a.`DEF_id`=p.`REF|leginondata|AcquisitionImageData|image`
WHERE sp.`REF|ApStackData|stack` = 59