Uncategorised

SELECT
                    r.*,
                    d.disorder AS disorder_name,
                    d.icon AS disorder_icon,
                    ds.*,
                    l.*,
                    p.*
                FROM `reports` AS r
                LEFT JOIN `disorders` AS d
                    ON d.disorder_id = r.disorder_id
                LEFT JOIN `descriptions` AS ds
                    ON ds.description_id = r.description_id
                LEFT JOIN `locations` AS l
                    ON l.location_id = r.location_id
                LEFT JOIN `places` AS p
                    ON p.place_id = r.place_id
                WHERE r.published = 1
                ORDER BY r.modified DESC
                LIMIT :limit