SELECT 
  descriptions.identify,
  CONCAT('[', categories.code, '] ', categories.name) AS category,
  CONCAT(categories.code, ' ', identifications.number) AS number,
  (SELECT users.caption FROM users WHERE users.identify = descriptions.owner LIMIT 1) AS owner,
  identifications.folder,
  CONCAT('(', countries.name, ') ', locations.name) AS location,
  IF(descriptions.owner = ".$_SESSION["identify"].", 'N', 'Y') AS blocked,
  IFNULL((SELECT COUNT(files.identify) FROM files WHERE files.identification = descriptions.identification GROUP BY files.identification LIMIT 1), 0) AS attached,
  countries.name,
  descriptions.title,
  descriptions.recorded,
  descriptions.encoded,
  descriptions.timekeeping,
  descriptions.notes,
  descriptions.published,
  IFNULL((SELECT GROUP_CONCAT(CONCAT('<b>', characters.name, ':</b> ', styles.name) ORDER BY characters.name SEPARATOR '<br>')
  FROM styles INNER JOIN creations ON (styles.identify = creations.style) INNER JOIN characters ON (styles.character = characters.identify) 
  WHERE creations.description = descriptions.identify GROUP BY creations.description), '') AS d_creations,
  IFNULL((SELECT GROUP_CONCAT(CONCAT('<b>', languages.name, ':</b> ', indications.notes) ORDER BY languages.code SEPARATOR '<br>')
  FROM indications INNER JOIN languages ON (indications.language = languages.identify)
  WHERE indications.description = descriptions.identify GROUP BY indications.description), '') AS d_indications,
  IFNULL((SELECT GROUP_CONCAT(CONCAT('<b>', contributions.name, ':</b> ', CONCAT(people.first_name, ' ', people.last_name, ', <span style=\'color:#747474\'>[n&#259;scut(&#259;)', IF(people.birthyear <> '', CONCAT(' la ', people.birthyear), ''), ' &#238;n ', countries.name, ']</span>')) ORDER BY countries.code SEPARATOR '<br>')
  FROM people INNER JOIN collaborations ON (people.identify = collaborations.person) INNER JOIN countries ON (people.country = countries.identify) INNER JOIN contributions ON (collaborations.contribution = contributions.identify)
  WHERE collaborations.description = descriptions.identify GROUP BY collaborations.description), '') AS d_collaborations,
  IFNULL((SELECT GROUP_CONCAT(CONCAT('<b>', contributions.name, ':</b> ', CONCAT(teams.name, ', <span style=\'color:#747474\'>[din ', countries.name, IF(IFNULL(tools.name, '') <> '', CONCAT(', c&#226;nt&#259; la ', tools.name), ''), ']</span>')) ORDER BY countries.code SEPARATOR '<br>')
  FROM teams INNER JOIN countries ON (countries.identify = teams.country) LEFT JOIN tools ON (teams.tool = tools.identify) INNER JOIN interpretations ON (teams.identify = interpretations.team) INNER JOIN contributions ON (interpretations.contribution = contributions.identify)
  WHERE interpretations.description = descriptions.identify GROUP BY interpretations.description), '') AS d_interpretations
FROM 
  identifications
  LEFT JOIN descriptions ON (identifications.identify = descriptions.identification)
  LEFT JOIN categories ON (identifications.category = categories.identify)
  LEFT JOIN locations ON (descriptions.location = locations.identify)
  LEFT JOIN countries ON (locations.country = countries.identify) 
ORDER BY
  categories.code,
  identifications.number
LIMIT 
  0, 50;