Kayako queries get left join articles

On 03.20.12, In 4, Mysql, by Samuel east
Needed to run a query to pullout all kayako downloads based on id.
SELECT swkbarticles.subject, swkbarticlelinks.kbarticleid, swkbarticlelinks.linktypeid, swattachments.filename FROM `swkbarticles`
LEFT JOIN swkbarticlelinks
ON swkbarticles.kbarticleid=swkbarticlelinks.kbarticleid
LEFT JOIN swattachments
ON swkbarticlelinks.linktypeid= swattachments.linktypeid
WHERE swkbarticlelinks.linktypeid = 167