DEV BUILD (branch: master) - NOT FOR PUBLIC USE
 

Check out our latest Fleet Action!

 

Part of Starbase Bravo: Conscientious Objection

Borg DNA Removal: Narrowing Suspects

Sector Alpa-Red
Couple of days Post-The Borg DNA Removal Team's meeting
0 likes 407 views

Just a few days had elapsed since the illustrious meeting on Deck 55, but Ensign Solari’s unwavering diligence had already yielded significant progress in identifying any suspicious activities spanning from one month before Frontier Day to the day prior.

The challenge lay in determining how far back Cam needed to investigate and precisely what he should be searching for. Fortunately, the program he had designed to assist him proved effective, with easily adjustable filters. It was still akin to searching for a needle in a haystack, and much of the data required his personal scrutiny.

Currently, Cam found himself in possession of separate office space, a welcome change that he readily embraced. This development was primarily thanks to his inquisitive colleague, Lieutenant Praga, who had been overly curious about Cam’s activities since he was summoned to the Director’s office and seemed to vanish for a few days.

Up to this point, Cam’s only substantial achievement had nothing to do with the original directive. He had stumbled upon some questionable Ferengi individuals involved in what appeared to be the sale of stolen equipment. Cam promptly reported this to Director Peri’s office, resulting in the Ferengi’s apprehension a few hours later. This accomplishment left Cam feeling rather satisfied, even eliciting a chuckle.

Cam was deeply engrossed in sifting through another list of potentially suspicious activities when his commbadge chimed, and the voice of one of the Lieutenants who had attended the meeting came through.

“Oin’sun to Solari.”    

“Yes, Lieutenant? How can I assist you?” Cam inquired, his curiosity now piqued.

“I wanted to touch base to see how your work is coming along? I have been going over the transporter logs for the last couple of months and have identified a list of all civilians who have used the transporters during this time. I have no idea when the transporter systems were tampered with but there was a slight increase in malfunctions reported across the station around this time. The repair work seemed to be linked to a power disruption so I am not sure they are linked. I have highlighted several ships that had people beam to in the lead-up to Frontier Day. The odd thing is that they were docked so beaming over doesn’t fit. I am sending you their IDs if you could dig up any more information.”

A moment later Cam’s PADD had an alert come up stating an unread message was waiting. 

Cam meticulously reviewed the message displayed on his PADD, making precise adjustments to his search program parameters. 

He then instructed, “Computer, perform a comprehensive cross-reference of the newly added data’s IDs in the period we have established.”

The computer fell into a brief silence, its digital gears whirring as it processed the data. After a moment, it calmly reported, “The result indicates there are eighteen thousand, three hundred and fifty-six potential threats.”

Cam paused in contemplation for a moment before issuing his next command. “Computer,” he began, “now cross-reference these results with the exhaustive dataset we’ve diligently compiled throughout the past week.”

This time, the computer’s brief silence didn’t last as long. After only a moment, it calmly stated, “The result shows two hundred and thirteen potential threats.”

Cam’s sense of progress gave him a glimmer of hope, but he realized that he needed assistance to sift through the extensive records. Without hesitation, Cam swiftly pressed his communicator and uttered, 

“Solari to Oin’sun, Lieutenant, you better get down here.”

Cynndle looked up from the console he was working at and tapped his combadge, “Sure thing.” With that, he got up and made his way to the offices Solari was using. 

About 10 minutes after they had spoken Cynndle walked into the space. “So I guess you found something interesting?” 

Cam eagerly thrust his PADD beneath Oin’Sun’s nose.

“Take a look at this! I cross-referenced the IDs you provided with the data I’ve been compiling leading up to Frontier Day.”

“I gathered, what did you find?”

“These findings represent only two hundred and thirteen results out of thousands! I called you with the faint hope of sorting through it together, but in the short time it took you to arrive, I stumbled upon something,” Cam exclaimed, his eyes brimming with excitement.

Cynndle looked at the young ensigned, “And?”

“Apologies, Lieutenant,” the young Ensign said, continuing, “I observed that these are the same five ships that were docked during Transporter maintenance, every time. What’s more, these dockings were cleared by two different Flight Ops officers each time, which is highly unusual.”

“That is very odd. Something to look into for sure.”

Cam fell silent for a moment and then responded with a grave tone, “Lieutenant Commander Francka and Lieutenant Hanson. I work with them, or rather, I work for them. I don’t know what to do.”

Cynndle glanced back at the door then at the PADD, “Well for starters we should inform Lieutenant Commander Peri about this and about Francka and Hanson. At the very least it is damned odd, at the worst, they could be changelings though I hate to suspect someone based on only a little evidence. We should also pass on the information about the ships so that it can be disseminated to the fleet so they can be tracked down if needed.” 

He paused for a moment, “Either way these are complications that we cannot let slide.”

Their eyes met, and in that silent exchange, they both felt a surge of excitement coursing through them. It was the kind of thrill that came from a puzzle’s final piece falling into place. Ensign Solari’s fingers danced over the holographic controls as he prepared the data for transmission, while Lieutenant Oin’Sun’s sharp gaze remained fixed on the screen, ensuring that every crucial detail was included.

As Ensign Solari initiated the transmission, the information flowed out in a stream of encrypted data packets, like a message being sent across the vast reaches of space. They knew that Director Peri’s discerning eyes would soon dissect the intricate web of connections they had unearthed. Their findings were more than just information; they were a beacon of hope in a complex investigation that had tested their skills and resolve.

With the data on its way to Lieutenant Commander Peri, they shared a silent nod, acknowledging the significance of their discovery. It was a moment that would shape the course of their mission, one they wouldn’t soon forget.

Load Time: 0.3 seconds

Total SQL Queries: 85

2 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (87779) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '87779' AND wp_posts.post_type = 'story' ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1036) ORDER BY umeta_id ASC
1 SELECT wp_users.* FROM wp_users WHERE 1=1 AND wp_users.ID IN (1036,1759,2374) ORDER BY user_login ASC
1 SELECT * FROM wp_posts WHERE ID = 15539 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34940) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34940 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135915 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135016 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 85186 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 134177 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45547 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 64893 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 50922 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 49736 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135423 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 69902 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45969 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 99730 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 97998 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1759) ORDER BY umeta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2374) ORDER BY umeta_id ASC
1 SELECT meta_id FROM wp_postmeta WHERE meta_key = 'views' AND post_id = 87779
1 SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('group_news_category') AND tr.object_id IN (140618, 140922) ORDER BY t.name ASC
1 SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT * FROM wp_posts WHERE ID = 86412 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 13085 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (122202)
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'event_status' AND wp_postmeta.meta_value = 'In Progress' ) AND ( mt1.meta_key = 'event_type' AND mt1.meta_value = 'fleet_action' ) ) AND wp_posts.post_type = 'events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140618,140922) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (140922,140618)
1 SHOW FULL COLUMNS FROM `wp_postmeta`
1 SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'group_news' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 2
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (101895) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 101895 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (84910) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60772) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 60772 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51876) ORDER BY meta_id ASC
1 UPDATE `wp_postmeta` SET `meta_value` = '407' WHERE `post_id` = 87779 AND `meta_key` = 'views'
1 SELECT * FROM wp_posts WHERE ID = 28801 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 66848 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 54182 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 15311 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 84478 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 84069 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 90425 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 64713 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 70888 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 69124 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 27036 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34941) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 66732 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '0' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 34941 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86473) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 86473 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 84910 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 51876 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2063) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2063' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 59583 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 98656 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 92044 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 140049 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 98862 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 101386 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 78989 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 97973 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 70939 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 85090 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 106254 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 131413 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45973 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135712 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 136694 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 138038 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12908 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 136318 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45970 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 74462 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45909 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1