How to SELECT multi-columns from a column?
SELECT t0.book_id, t0.select_id, t0.note_id, t1.TEXT_number_1, t2.TEXT_number_2
FROM (SELECT DISTINCT book_id, select_id, note_id
      FROM `table`) t0
LEFT JOIN `table` t1 ON t0.book_id=t1.book_id
                     AND t1.item_number=1   
                  /* AND t0.select_id=t1.select_id 
                     AND t0.note_id=t1.note_id */
LEFT JOIN `table` t2 ON t0.book_id=t2.book_id 
                     AND t2.item_number=2   
                  /* AND t0.select_id=t2.select_id 
                     AND t0.note_id=t2.note_id */