08-25-2026 21:06:14 SQL Statement: SELECT id, account_number, company_name, first_name, last_name, status, auto_inactive_enable, inactivation, billing_type, parent, wholesale, child, credit_card_failure, account_manager FROM customer WHERE id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT id, summary, description FROM billing_styles ORDER BY id

08-25-2026 21:06:14 SQL Statement: SELECT contact_data.id, contact_data.email, contact_data.name_contact, contact_data.phone, contact_data.fax, customer_contact_data.customer_id FROM contact_data, customer_contact_data WHERE contact_data.id = customer_contact_data.contact_id AND customer_contact_data.customer_id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id = '27' ORDER BY trunk_number

08-25-2026 21:06:14 SQL Statement: SELECT t.id, t.childId, t.parentId, t.childAccountNum, t.childStatus, t.childDeactive, t.childFirstName, t.childLastName, t.childCompany, t.parentAccountNum, t.parentWholesale, t.parentFirstName, t.parentLastName, t.parentCompany FROM (SELECT pair.id AS id, pair.child_id AS childId, pair.parent_id AS parentId, c.account_number AS childAccountNum, c.status AS childStatus, c.inactivation AS childDeactive, c.first_name AS childFirstName, c.last_name AS childLastName, c.company_name AS childCompany, p.account_number AS parentAccountNum, p.wholesale AS parentWholesale, p.first_name AS parentFirstName, p.last_name AS parentLastName, p.company_name AS parentCompany FROM customer_parent_child pair LEFT JOIN customer c ON pair.child_id = c.id LEFT JOIN customer p ON pair.parent_id = p.id) AS t WHERE t.parentId = '27' ORDER BY t.parentId

08-25-2026 21:06:14 SQL Statement: SELECT id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id IN (NULL) ORDER BY trunk_number

08-25-2026 21:06:14 SQL Statement: SELECT COUNT(*) AS quantity FROM customer_device_info WHERE customer_id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT customer_device_id, device_info_id, customer_id, account_number, first_name, last_name, company_name, status, inactivation, box_num, mac_address, ip_address, port_number, allow_changing_port, follow_changing_port, canreinvite, admin_email, notes, type, typeName, box_serial, software_serial, extension_count, acd_extension_count, support_end_date, update_end_date, http_address, lan_ip, ssh_port, web_port, require_vlan, ssl_enable, voip_pw, pbxadmin_pw, eula_agreement, eula_addendum1_agreement, support_agreement FROM customer_device_info WHERE customer_id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT COUNT(*) AS quantity FROM trunk WHERE customer_id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT id, customer_id, sipserver_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id = '27'

08-25-2026 21:06:14 SQL Statement: SELECT COUNT(*) AS quantity FROM sipServers WHERE serverID = ''

08-25-2026 21:06:14 SQL Statement: SELECT trunk_number, call_type_id, carrier_ids FROM trunkCalltypeCarrierPriorities WHERE trunk_number = '27' ORDER BY call_type_id

08-25-2026 21:06:15 SQL Statement: SELECT id, name, host, accountcode, priorityDomestic, priorityInternational, priorityE911, priorityE411, dialstringDomestic, dialstringInternational, dialstringSpecial, addressStyle, tcp_enable, port FROM carriersOutbound ORDER BY name

08-25-2026 21:06:15 SQL Statement: SELECT billPlan.bpID, billPlan.s_date, billPlan.nextBillDate, billPlan.setupFee_E411, billPlan.perCall_E411, billPlan.perCall_E411, billPlan.perCall_E911, billPlan.perCall_Rogue911, billPlan.stateTax, billPlan.USinInitialCharge, billPlan.USoutInitialCharge, billPlan.USin2ndCharge, billPlan.USout2ndCharge, billPlan.InternationalinInitialCharge, billPlan.InternationaloutInitialCharge, billPlan.InternationalinAfterCall, billPlan.InternationaloutAfterCall, billPlan.inRate, billPlan.outRate, billPlan.perCall_tollFree, billPlan.TollFreeInitialCharge, billPlan.TollFreeAfterCharge, billPlan.usf_enable, billPlan.baseAmount, billPlan.trunkRate, billPlan.trunksIn, billPlan.trunksIn, billPlan.trunksOut, billPlan.STD_In_numbersPorted, billPlan.STD_In_numberPortingFee, billPlan.STD_Out_numbersPorted, billPlan.STD_Out_numberPortingFee, billPlan.tollFree_In_numbersPorted, billPlan.tollFree_In_numberPortingFee, billPlan.tollFree_Out_numbersPorted, billPlan.tollFree_Out_numberPortingFee, billPlan.setupFee_InitialDID, billPlan.DIDMonthlyFee, billPlan.setupFee_tollFree, billPlan.DIDMonthlyFee_tollFree, billPlan.phoneBookListing, billPlan.numPhoneBookListings, billPlan.paperInvoiceFee, billPlan.planID, billPlan.inPack, billPlan.outPack, billPlan.combinedSecs, billPlan.cidFee, billPlan.sms_rate, billPlan.mms_rate, billPlan.smsout_rate, billPlan.cardRejectFee, billPlan.PerChild50, billPlan.PerChild100, billPlan.PerChild250, billPlan.PerChild500, billPlan.PerChild1000, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT COUNT(*) AS quantity FROM cc_data WHERE customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT btID, customer_id, tankbalance, TFInbound, amountDue, pastDue, pastDue30, pastDue60, pastDue90, totalInMinutesAllowed, totalOutMinutesAllowed, totalCombinedMinutesAllowed FROM billTotal WHERE customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_agent WHERE customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesrep WHERE customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesmanager WHERE customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = ''

08-25-2026 21:06:15 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = ''

08-25-2026 21:06:15 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = ''

08-25-2026 21:06:15 SQL Statement: SELECT did_id, did, startTimestamp, carrier_id, forward_number, forward_delay, cnam_enable, e911_enable, dial_format, did_tag, did_description, carrier_name, customer_id, account_number, customer_first_name, customer_last_name, customer_company, customer_status, customer_hardinactive, trunk_id, trunk_number, sipserver_id, international_enable FROM customer_did WHERE customer_id = '27' ORDER BY did

08-25-2026 21:06:15 SQL Statement: SELECT id, account_number, company_name, first_name, last_name, status, auto_inactive_enable, inactivation, billing_type, parent, wholesale, child, credit_card_failure, account_manager FROM customer WHERE id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT billPlan.bpID, billPlan.planName, billPlan.term, billPlan.s_date, billPlan.nextBillDate, billPlan.billingDays, billPlan.gracePeriod, billPlan.external_tax_processing, billPlan.external_tax_filing, billPlan.threshold, billPlan.threshold_type, billPlan.chargeAmount, billPlan.recharge_type, billPlan.cutoff_value, billPlan.international_enable, billPlan.international_enable_style, billPlan.international_warning_minutes, billPlan.international_cutoff_minutes, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '27'

08-25-2026 21:06:15 SQL Statement: SELECT id, username, password_hash, access_type, customer_id, AES_DECRYPT(password, '0mp7wmvTCmqU7jLXN4CT') AS password FROM login WHERE username = '10059'