SELECT
    *
FROM
    brands AS b,
    yetkili AS y,
    etkinlik AS e,
    rezervasyon AS r
LEFT JOIN y ON y.yetkili_id = e.org_yetkili_id
LEFT JOIN b ON b.brand_id = e.org_brand_id
LEFT JOIN b ON b.brand_id = r.rez_brand_id
LEFT JOIN y ON y.yetkili_id = r.rez_yetkili_id
ORDER BY
    b.brand_id
DESC