# Time: 140301 11:52:06
# User@Host: beaker[beaker] @ localhost [127.0.0.67]
# Query_time: 19  Lock_time: 0  Rows_sent: 0  Rows_examined: 2992525
SELECT command_queue.status AS command_queue_status, system.status AS system_status, system.id AS system_id, system.fqdn AS system_fqdn, system.serial AS system_serial, system.date_added AS system_date_added, system.date_modified AS system_date_modified, system.date_lastcheckin AS system_date_lastcheckin, system.location AS system_location, system.vendor AS system_vendor, system.model AS system_model, system.lender AS system_lender, system.owner_id AS system_owner_id, system.user_id AS system_user_id, system.type AS system_type, system.status_reason AS system_status_reason, system.private AS system_private, system.deleted AS system_deleted, system.memory AS system_memory, system.checksum AS system_checksum, system.lab_controller_id AS system_lab_controller_id, system.mac_address AS system_mac_address, system.loan_id AS system_loan_id, system.loan_comment AS system_loan_comment, system.release_action AS system_release_action, system.reprovision_distro_tree_id AS system_reprovision_distro_tree_id, system.hypervisor_id AS system_hypervisor_id, system.kernel_type_id AS system_kernel_type_id, activity.id AS activity_id, command_queue.id AS command_queue_id, activity.user_id AS activity_user_id, activity.created AS activity_created, activity.type AS activity_type, activity.field_name AS activity_field_name, activity.service AS activity_service, activity.action AS activity_action, activity.old_value AS activity_old_value, activity.new_value AS activity_new_value, command_queue.system_id AS command_queue_system_id, command_queue.task_id AS command_queue_task_id, command_queue.delay_until AS command_queue_delay_until, command_queue.updated AS command_queue_updated, command_queue.callback AS command_queue_callback, command_queue.distro_tree_id AS command_queue_distro_tree_id, command_queue.kernel_options AS command_queue_kernel_options 
FROM activity INNER JOIN command_queue ON activity.id = command_queue.id INNER JOIN system ON system.id = command_queue.system_id 
WHERE 8 = system.lab_controller_id AND command_queue.status = 'Queued' ORDER BY activity.id;