SELECT cards.cardId, question, study_stage, deckId, last_timestamp, GROUP_CONCAT(image_path SEPARATOR '|') as images FROM cards LEFT JOIN images ON images.cardId = cards.cardId where cards.cardId = 1 GROUP BY cards.cardId;