Commission Recipient

08-25-2026 21:06:37 SQL Statement: SELECT id, active, first_name, last_name, company_name, phone, address1, address2, city, state, zip, notes, tax_id, ssn FROM commission_contact WHERE id = '2'

08-25-2026 21:06:37 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_portal_users WHERE commission_contact_id = '2'

08-25-2026 21:06:37 SQL Statement: SELECT id, username, password_hash, commission_contact_id FROM commission_portal_users WHERE commission_contact_id = '2'

08-25-2026 21:06:37 SQL Statement: SELECT t.id, t.commission_contact_id, t.customer_id, t.commission_type, t.fixed_amount, t.percentage, t.active, t.first_name, t.last_name, t.company_name, t.phone, t.address1, t.address2, t.city, t.state, t.zip, t.notes, t.tax_id, t.ssn, t.account_number, t.customer_first_name, t.customer_last_name, t.customer_company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child FROM (SELECT agent.id AS id, agent.commission_contact_id AS commission_contact_id, agent.customer_id AS customer_id, agent.commission_type AS commission_type, agent.fixed_amount AS fixed_amount, agent.percentage AS percentage, contact.active AS active, contact.first_name AS first_name, contact.last_name AS last_name, contact.company_name AS company_name, contact.phone AS phone, contact.address1 AS address1, contact.address2 AS address2, contact.city AS city, contact.state AS state, contact.zip AS zip, contact.notes AS notes, contact.tax_id AS tax_id, contact.ssn AS ssn, c.account_number AS account_number, c.first_name AS customer_first_name, c.last_name AS customer_last_name, c.company_name AS customer_company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child FROM commission_agent agent LEFT JOIN commission_contact contact ON contact.id = agent.commission_contact_id LEFT JOIN customer c ON c.id = agent.customer_id) AS t WHERE t.commission_contact_id = '2' ORDER BY t.account_number

08-25-2026 21:06:37 SQL Statement: SELECT t.id, t.commission_contact_id, t.customer_id, t.commission_type, t.fixed_amount, t.percentage, t.active, t.first_name, t.last_name, t.company_name, t.phone, t.address1, t.address2, t.city, t.state, t.zip, t.notes, t.tax_id, t.ssn, t.account_number, t.customer_first_name, t.customer_last_name, t.customer_company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child FROM (SELECT rep.id AS id, rep.commission_contact_id AS commission_contact_id, rep.customer_id AS customer_id, rep.commission_type AS commission_type, rep.fixed_amount AS fixed_amount, rep.percentage AS percentage, contact.active AS active, contact.first_name AS first_name, contact.last_name AS last_name, contact.company_name AS company_name, contact.phone AS phone, contact.address1 AS address1, contact.address2 AS address2, contact.city AS city, contact.state AS state, contact.zip AS zip, contact.notes AS notes, contact.tax_id AS tax_id, contact.ssn AS ssn, c.account_number AS account_number, c.first_name AS customer_first_name, c.last_name AS customer_last_name, c.company_name AS customer_company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child FROM commission_salesrep rep LEFT JOIN commission_contact contact ON contact.id = rep.commission_contact_id LEFT JOIN customer c ON c.id = rep.customer_id) AS t WHERE t.commission_contact_id = '2' ORDER BY t.account_number

08-25-2026 21:06:37 SQL Statement: SELECT t.id, t.commission_contact_id, t.customer_id, t.commission_type, t.fixed_amount, t.percentage, t.active, t.first_name, t.last_name, t.company_name, t.phone, t.address1, t.address2, t.city, t.state, t.zip, t.notes, t.tax_id, t.ssn, t.account_number, t.customer_first_name, t.customer_last_name, t.customer_company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child FROM (SELECT manager.id AS id, manager.commission_contact_id AS commission_contact_id, manager.customer_id AS customer_id, manager.commission_type AS commission_type, manager.fixed_amount AS fixed_amount, manager.percentage AS percentage, contact.active AS active, contact.first_name AS first_name, contact.last_name AS last_name, contact.company_name AS company_name, contact.phone AS phone, contact.address1 AS address1, contact.address2 AS address2, contact.city AS city, contact.state AS state, contact.zip AS zip, contact.notes AS notes, contact.tax_id AS tax_id, contact.ssn AS ssn, c.account_number AS account_number, c.first_name AS customer_first_name, c.last_name AS customer_last_name, c.company_name AS customer_company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child FROM commission_salesmanager manager LEFT JOIN commission_contact contact ON contact.id = manager.commission_contact_id LEFT JOIN customer c ON c.id = manager.customer_id) AS t WHERE t.commission_contact_id = '2' ORDER BY t.account_number