"SELECT partners.username as admin_name, partners.id as partner_id, "
                . "IF(clients.firm=0,CONCAT(lastname,' ',firstname),firm_name) as client_name, "
                . "date, wireless_packets.packet_name as new_packet_name, "
                . "wp2.packet_name as old_packet_name, storno, scheduling_id, "
                . "wireless_history.id as histid, mb, IF(DATE_ADD(date,INTERVAL 1 DAY) > NOW(), 0,1) as storno_expired "
                . "FROM wireless_history "
                . "LEFT JOIN clients ON clients.id = wireless_history.client_id "
                . "LEFT JOIN wireless_packets ON new_packet = wireless_packets.id "
                . "LEFT JOIN wireless_packets wp2 ON wireless_history.packet = wp2.id "
                . "LEFT JOIN partners ON partners.id = wireless_history.partner_id "
                . "WHERE wireless_history.wireless_id =$id "
                . "ORDER BY date DESC";