SELECT c.id cid, c.*, cc.* FROM gallery c JOIN gallerycontent cc ON cc.galleryID = c.id AND cc.languageID = 'no'

  • MEDICAL
  • BROWS
  • LIPS
  • EYES