UntouchedWagons

This is the receiver I have: https://www.amazon.ca/gp/product/B00ZB7W4QU/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1

And this is the controller I have: https://www.amazon.ca/gp/product/B08DF26MXW/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1

If I try to connect the controller using bluetooth my deck can see the controller but can't establish a connection. Is there an addon I can install so that I can use the usb receiver I currently have?

The title is indeed terrible but I have no idea what to put. I am working on a Bill of Materials app and I'm starting out with the database layout and the REST API to interact with the database.

I currently have four tables but the query I want to write involves three of them

CREATE TABLE `components` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `price` float unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `products` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `tax_code` varchar(8) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `name_idx` (`tax_code`),
  CONSTRAINT `name` FOREIGN KEY (`tax_code`) REFERENCES `tax_codes` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `product_components` (
  `product_id` int(10) unsigned NOT NULL,
  `component_id` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`component_id`),
  KEY `fk_component_id_idx` (`component_id`),
  CONSTRAINT `fk_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`),
  CONSTRAINT `fk_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Now what I want to do is list all the products and for each product calculate the cost of all the components that product needs. So if a product needs 4 doodads that cost $1 and 7 whatzits that cost $2 the cost of the product would be $18 (41 + 72). I know I'd need some JOINs but I have no idea what I'd need.

I'm going on a trip tomorrow and want to be able to access jellyfin remotely but port forwarding JF isn't an option. I already have Wireguard set up on my pfsense router and my phone can VPN in just fine. I used to have a tablet so I reused its config for my steam deck. I SSH'd the config file over, imported in Network Manager. But when I activate the Wireguard VPN nearly the entire UI stops responding. The power button works and I can bring up the on-screen keyboard but that's it. My only option is to hold down the power button to force the deck to shut down.

Anyone have any ideas what's going on?

Any torrent from TorrentLeach that I try cannot be added to qbittorrent, if I press F12 in Firefox and try to a torrent I see the error [HTTP/2 415 Unsupported Media Type 19ms]. If I try a torrent of say Debian or Ubuntu it works just fine. Anyone else seen something like this before?