SELECT
  `batches_fragmentation.location` AS 'location',
  `batches_fragmentation.timestamp` AS 'timestamp',
  `batches_fragmentation.frag_image` AS 'frag_image',
  `batches_fragmentation.mode_image` AS 'model_image',
  `batches.name` AS 'name'
FROM `batches_fragmentation`
LEFT JOIN `batches` USING `uid` 
WHERE `batches_fragmentation.uid`='fraguid'
LIMIT 1;