categorysteamapplink

Table actions

Data source: steam-to-sqlite

11 rows where steam_app_pk = 166

✎ View and edit SQL

This data as json, CSV (advanced)

Link category_pk steam_app_pk
1,166 1 1 Half-Life 2: Lost Coast 166
32,166 32 32 Half-Life 2: Lost Coast 166
285,166 285 285 Half-Life 2: Lost Coast 166
287,166 287 287 Half-Life 2: Lost Coast 166
290,166 290 290 Half-Life 2: Lost Coast 166
291,166 291 291 Half-Life 2: Lost Coast 166
292,166 292 292 Half-Life 2: Lost Coast 166
295,166 295 295 Half-Life 2: Lost Coast 166
297,166 297 297 Half-Life 2: Lost Coast 166
298,166 298 298 Half-Life 2: Lost Coast 166
299,166 299 299 Half-Life 2: Lost Coast 166

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "categorysteamapplink" (
	category_pk INTEGER NOT NULL, 
	steam_app_pk INTEGER NOT NULL, 
	PRIMARY KEY (category_pk, steam_app_pk), 
	FOREIGN KEY(steam_app_pk) REFERENCES steam_app (pk), 
	FOREIGN KEY(category_pk) REFERENCES category (pk)
);