Example Query

// Example query.
// In this case, we are querying for any member who resides in NM or is licensed in NM

Array
(
    [fields] => Array
        (
            [0] => EventsMembersAction.*
            [1] => (1) AS opt_in
            [2] => MemberFieldJ.value
        )

    [limit] => 1000
    [contain] => Array
        (
            [Eval] => Array
                (
                    [fields] => Array
                        (
                            [0] => id
                        )

                )

            [Member] => Array
                (
                    [fields] => Array
                        (
                            [0] => id
                            [1] => first_name
                            [2] => last_name
                            [3] => email
                            [4] => address
                            [5] => address_2
                            [6] => city
                            [7] => state
                            [8] => zip
                            [9] => phone
                            [10] => country
                        )

                )

        )

    [conditions] => Array
        (
            [0] => EventsMembersAction.data > 79
            [EventsMembersAction.action] => exam
            [EventsMembersAction.event_id] => 6200
            [OR] => Array
                (
                    [MemberJ.state] => NM
                    [MemberStateLicenseJ.state] => NM
                )

            [EventsMembersAction.created between ? AND ?] => Array
                (
                    [0] => 2015-03-25 00:00:00
                    [1] => 2015-03-26 23:59:59
                )

        )

    [order] => Array
        (
            [0] => EventsMembersAction.event_id ASC
            [1] => Member.last_name ASC
            [2] => Member.first_name ASC
        )

    [joins] => Array
        (
            [0] => Array
                (
                    [table] => members
                    [alias] => MemberJ
                    [type] => INNER
                    [conditions] => Array
                        (
                            [0] => MemberJ.id=EventsMembersAction.member_id
                        )

                )

            [1] => Array
                (
                    [table] => member_state_licenses
                    [alias] => MemberStateLicenseJ
                    [type] => INNER
                    [conditions] => Array
                        (
                            [AND] => Array
                                (
                                    [0] => MemberJ.id = MemberStateLicenseJ.member_id
                                    [OR] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [MemberStateLicenseJ.state] =>
                                                )

                                            [1] => Array
                                                (
                                                    [MemberJ.state] => NM
                                                )

                                        )

                                )

                        )

                )

            [2] => Array
                (
                    [table] => members_fields
                    [alias] => MemberFieldJ
                    [type] => LEFT
                    [conditions] => Array
                        (
                            [AND] => Array
                                (
                                    [0] => EventsMembersAction.member_id = MemberFieldJ.member_id
                                    [1] => Array
                                        (
                                            [key] => occupation
                                        )

                                )

                        )

                )

        )

    [group] => EventsMembersAction.id
)