Wholesaler Device Associations

08-25-2026 21:53:48 SQL Statement: SELECT t.device_id, t.box_number, t.mac_address, t.ip_address, t.change_port, t.admin_email, t.notes, t.type_id, t.type_name, t.wholesaler_id, t.wholesaler_account FROM (SELECT device.id AS device_id, device.box_num AS box_number, device.mac_address AS mac_address, device.ip_address AS ip_address, device.allow_changing_port AS change_port, device.admin_email AS admin_email, device.notes AS notes, devicetype.id AS type_id, devicetype.typeName AS type_name, wholesaler.id AS wholesaler_id, wholesaler.account_number AS wholesaler_account FROM device_info device LEFT JOIN device_type devicetype ON device.type = devicetype.id LEFT JOIN wholesaler_device wholesale_link ON device.id = wholesale_link.device_id LEFT JOIN customer wholesaler ON wholesale_link.wholesaler_id = wholesaler.id) AS t WHERE t.wholesaler_id = '28' ORDER BY t.box_number

08-25-2026 21:53:48 SQL Statement: SELECT t.device_id, t.box_number, t.mac_address, t.ip_address, t.changing_port, t.admin_email, t.notes, t.type_id, t.type_name, t.wholesale_id, t.wholesale_account, t.customer_id, t.customer_account, t.customer_firstname, t.customer_lastname, t.customer_company, t.customer_parent_id FROM (SELECT device.id AS device_id, device.box_num AS box_number, device.mac_address AS mac_address, device.ip_address AS ip_address, device.allow_changing_port AS changing_port, device.admin_email AS admin_email, device.notes AS notes, devicetype.id AS type_id, devicetype.typeName AS type_name, wholesaler.id AS wholesale_id, wholesaler.account_number AS wholesale_account, child.id AS customer_id, child.account_number AS customer_account, child.first_name AS customer_firstname, child.last_name AS customer_lastname, child.company_name AS customer_company, customer_parent.parent_id AS customer_parent_id FROM device_info device LEFT JOIN device_type devicetype ON device.type = devicetype.id LEFT JOIN wholesaler_device wholesale_link ON device.id = wholesale_link.device_id LEFT JOIN customer wholesaler ON wholesale_link.wholesaler_id = wholesaler.id LEFT JOIN customer_device child_link ON device.id = child_link.deviceId LEFT JOIN customer child ON child_link.customer_id = child.id LEFT JOIN customer_parent_child customer_parent ON child.id = customer_parent.child_id) AS t WHERE t.wholesale_id = '28' AND t.customer_parent_id = '28' ORDER BY t.box_number

08-25-2026 21:53:48 SQL Statement: SELECT id, box_num, mac_address, type, ip_address, port_number, allow_changing_port, follow_changing_port, admin_email, notes FROM device_info ORDER BY box_num

08-25-2026 21:53:48 SQL Statement: SELECT id, typeName, status FROM device_type ORDER BY typeName