query ndiyo hii

            SELECT
            p.firstname AS 'First Name',
            p.lastname AS 'Last Name',
            p.nationality AS Country,
            p.workaddress AS Organization,
            CASE p.gender
            WHEN  1 THEN 'Male'
            WHEN  0 THEN 'Female'
            END AS Gender,
            CONCAT_WS('/', `day`, `month`, `year`) AS 'Date of Birth',
            p.email AS 'Email Address',
            p.mobile AS 'Mobile Number',
            p.passport AS 'Passport Number / ID',
            e.highest_qualification AS 'Highiest Qualification',
            e.graduation_year AS 'Graduation Year',
            w.role AS Role,
            w.role_details AS 'Role Details',
            w.years_professional_experience AS 'Total Years of Professional Experience',
            w.number_of_years_in_org AS 'Years in Organization',
            w.individuals_supervised AS 'Employees Supervised',
            w.years_current_position AS 'Years in Current Position',
            w.sponsoring_organisation AS 'Sponsoring Organization',
            w.sponsoring_organisation_details AS 'Sponsoring Organization Details',
            w.sector AS 'Sector',
            CONCAT_WS('\n ', s.`statement_one`, s.`statement_two`, s.`statement_three`) AS 'Quality Statement'
            FROM  `profiles` p
            JOIN `educations` e ON p.user_id = e.user_id
            JOIN works w ON p.user_id = w.user_id
            JOIN `statements` s ON p.user_id = s.user_id