44 rows where weekday = 8

View and edit SQL

Suggested facets: length_loop, count_plays, time_range

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
50 10 180 10 So 8 1 1 1 1
51 10 180 10 So 8 2 2 1 1
52 10 180 10 So 8 3 3 1 1
53 10 180 10 So 8 4 4 1 1
54 10 180 10 So 8 5 5 1 1
55 10 180 10 So 8 6 6 1 1
56 10 180 10 So 8 7 7 1 1
106 10 180 20 So 8 1 1 1 1
107 10 180 20 So 8 2 2 1 1
108 10 180 20 So 8 3 3 1 1
109 10 180 20 So 8 4 4 1 1
110 10 180 20 So 8 5 5 1 1
111 10 180 20 So 8 6 6 1 1
112 10 180 20 So 8 7 7 1 1
162 10 180 40 So 8 1 1 1 1
163 10 180 40 So 8 2 2 1 1
164 10 180 40 So 8 3 3 1 1
165 10 180 40 So 8 4 4 1 1
166 10 180 40 So 8 5 5 1 1
167 10 180 40 So 8 6 6 1 1
168 10 180 40 So 8 7 7 1 1
218 10 180 60 So 8 1 1 1 1
219 10 180 60 So 8 2 2 1 1
220 10 180 60 So 8 3 3 1 1
221 10 180 60 So 8 4 4 1 1
222 10 180 60 So 8 5 5 1 1
223 10 180 60 So 8 6 6 1 1
224 10 180 60 So 8 7 7 1 1
274 10 180 80 So 8 1 1 1 1
275 10 180 80 So 8 2 2 1 1
276 10 180 80 So 8 3 3 1 1
277 10 180 80 So 8 4 4 1 1
278 10 180 80 So 8 5 5 1 1
279 10 180 80 So 8 6 6 1 1
280 10 180 80 So 8 7 7 1 1
288 10 60 1 So 8 1 1 1 1
296 10 60 18 So 8 1 1 1 1
304 10 60 36 So 8 1 1 1 1
312 10 60 54 So 8 1 1 1 1
320 10 60 72 So 8 1 1 1 1
328 10 60 90 So 8 1 1 1 1
336 10   20 So 8 1 1 1 1
344 10   30 So 8 1 1 1 1
352 10   60 So 8 1 1 1 1

Advanced export

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

CSV options:

CREATE TABLE spot_config (
	config_id INTEGER NOT NULL, 
	length_spot INTEGER, 
	length_loop INTEGER, 
	count_plays INTEGER, 
	weekday INTEGER, 
	time_range INTEGER, 
	published BOOLEAN, 
	is_standard BOOLEAN, 
	PRIMARY KEY (config_id), 
	UNIQUE (config_id), 
	FOREIGN KEY(weekday) REFERENCES weekday (id), 
	FOREIGN KEY(time_range) REFERENCES time_range (id)
);