A
Size: a a a
A
NL
AM
VS
VS
V
VS
V
VS
Z
K
K
AT
A
Ab
Ab
AT
A
SELECT table1.id, table2.name, table1.data, table3.title
FROM table1
INNER JOIN table2 ON table1.id = table2.ext
LEFT JOIN table3 ON table1.data = table3.group
WHERE table1.keyword = 'group'
ORDER BY table1.id