SELECT persons.personID, firstname, lastname, lecture, there 
FROM persons, lectures, person_lectures
WHERE  person_lectures.personID = persons.personID 
		AND person_lectures.lectureID = lectures.lectureID
		AND persons.personID = 1"

+----------+-----------+----------+---------+-------+
| personID | firstname | lastname | lecture | there |
+----------+-----------+----------+---------+-------+
|    1	   |    Jack   |   Ryan   |    L1   |  YES  |
+----------+-----------+----------+---------+-------+
|    1	   |    Jack   |   Ryan   |    L2   |  YES  |
+----------+-----------+----------+---------+-------+
|    1	   |    Jack   |   Ryan   |    L3   |   NO  |
+----------+-----------+----------+---------+-------+

+----------+-----------+----------+---------+---------+---------+
| personID | firstname | lastname |    L1   |    L2   |    L3   |
+----------+-----------+----------+---------+---------+---------+
|    1     |   Jack    |   Ryan   |   YES   |   YES   |    NO   |
+----------+-----------+----------+---------+---------+---------+

CREATE TABLE  persons
( personID TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY 
, firstname VARCHAR( 30 ) NOT NULL 
, lastname VARCHAR( 30 ) NOT NULL
) ENGINE = INNODB;

CREATE TABLE  lectures 
( lectureID TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY 
, lecture VARCHAR( 3 ) NOT NULL
, there VARCHAR( 3 ) NOT NULL
) ENGINE = INNODB;

CREATE TABLE person_lectures 
( personID TINYINT NOT NULL
, lectureID TINYINT NOT NULL 
, PRIMARY KEY ( personID, lectureID )
, INDEX person_lectures ( lectureID, personID )
, FOREIGN KEY ( personID ) REFERENCES persons ( personID )
, FOREIGN KEY ( lectureID ) REFERENCES lectures ( lectureID )
) ENGINE = INNODB;

SELECT persons.personID
     , persons.firstname
     , persons.lastname
     , MAX(CASE WHEN lecture='L1' THEN there ELSE NULL END) AS L1
     , MAX(CASE WHEN lecture='L2' THEN there ELSE NULL END) AS L2
     , MAX(CASE WHEN lecture='L3' THEN there ELSE NULL END) AS L3
  FROM persons
INNER
  JOIN person_lectures
    ON person_lectures.personID = persons.personID
INNER
  JOIN lectures
    ON lectures.lectureID = person_lectures.lectureID 
 WHERE persons.personID = 1
GROUP
    BY persons.personID

 WHERE persons.personID = 1

 WHERE persons.personID BETWEEN 1 AND 100

 WHERE persons.personID IN persons