SELECT t1.name, t1.parcel, t1.block, t1.share, t1.id, t2a.explanation, t2b.explanation, t2c.explanation
FROM table1 t1
LEFT OUTER JOIN
(
    SELECT t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    FROM table2 t21
    LEFT OUTER JOIN table2 t22
    ON t21.name = t22.name AND t21.surname = t22.surname AND t21.parcel = t22.parcel AND t21.block = t22.block AND t21.share = t22.share AND t21.id = t22.id AND t1.o > t2.no
    GROUP BY t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    HAVING COUNT(t22.No) = 0
) t2a ON t1.name = t2a.name AND t2.surname = t2a.surname AND t1.parcel = t2a.parcel AND t1.block = t2a.block AND t1.share = t2a.share AND t1.id = t2a.id
LEFT OUTER JOIN
(
    SELECT t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    FROM table2 t21
    LEFT OUTER JOIN table2 t22
    ON t21.name = t22.name AND t21.surname = t22.surname AND t21.parcel = t22.parcel AND t21.block = t22.block AND t21.share = t22.share AND t21.id = t22.id AND t1.o > t2.no
    GROUP BY t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    HAVING COUNT(t22.No) = 0
) t2b ON t1.name = t2b.name AND t2.surname = t2b.surname AND t1.parcel = t2b.parcel AND t1.block = t2b.block AND t1.share = t2b.share AND t1.id = t2b.id
LEFT OUTER JOIN
(
    SELECT t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    FROM table2 t21
    LEFT OUTER JOIN table2 t22
    ON t21.name = t22.name AND t21.surname = t22.surname AND t21.parcel = t22.parcel AND t21.block = t22.block AND t21.share = t22.share AND t21.id = t22.id AND t1.o > t2.no
    GROUP BY t21.name, t21.parcel, t21.block, t21.share, t21.id, t21.explanation
    HAVING COUNT(t22.No) = 0
) t2c ON t1.name = t2c.name AND t2.surname = t2c.surname AND t1.parcel = t2c.parcel AND t1.block = t2c.block AND t1.share = t2c.share AND t1.id = t2c.id

SELECT t1.name,
        t1.parcel,
        t1.block,
        t1.share,
        t1.id,
        SUBSTRING_INDEX(GROUP_CONCAT(t2.explanation ORDER BY t2.no SEPARATOR '~#~#~'), '~#~#~', 1),
        IF(COUNT(t2.no) >= 2, SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(t2.explanation ORDER BY t2.no SEPARATOR '~#~#~'), '~#~#~', 1), '~#~#~', -1), NULL),
        IF(COUNT(t2.no) >= 2, SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(t2.explanation ORDER BY t2.no SEPARATOR '~#~#~'), '~#~#~', 2), '~#~#~', -1), NULL)
FROM table1 t1
LEFT OUTER JOIN table2 t2
ON t1.name = t2.name AND t2.surname = t2.surname AND t1.parcel = t2.parcel AND t1.block = t2.block AND t1.share = t2.share AND t1.id = t2.id
GROUP BY t1.name,
        t1.parcel,
        t1.block,
        t1.share,
        t1.id