import MySQLdb

with open('data.csv', 'w') as file:
    conn = MySQLdb.connect(

              )

    cursor = conn.cursor()
    query = 'select id, fname, mname, lname, residence_add_l1, residence_add_l2, residence_city, residence_state, residence_pincode, office_add_l1, office_add_l2, office_city, office_state, office_pincode, dob, unverified_income, pan_number, occupation_type from contacts limit 10'
    cursor.execute(query)
    contacts = [[str(v) for v in value] for value in cursor.fetchall()]

    for contact in contacts:

        query = 'select phone_number in phone_numbers where contact_id={0} limit 3'.format(contact[0])
        cursor.execute(query)
        phone_numbers = [str(number) for number in cursor.fetchall()]
        for i in range(3):
            try:
                phone_numbers[i]
            except IndexError:
                phone_numbers[i] = ''


        query = 'select email in phone_numbers where contact_id={0} limit 3'.format(contact[0])
        cursor.execute(query)
        emails = [email for email in cursor.fetchall()]
        for i in range(3):
            try:
                emails[i]
            except IndexError:
                emails[i] = ''

        file.write(','.join(contact + phone_numbers + emails) + '\n')