SELECT c.id cid, c.*, cc.* FROM gallery c JOIN gallerycontent cc ON cc.galleryID = c.id AND cc.languageID = 'en'
  • MEDICAL
  • BROWS
  • LIPS
  • EYES