Custom SQL query

building

id, name_publisher, previous_id, poc_present, venue_id, count_screens

27,365 rows

meta_infos

id, key, value

4 rows

network

id, parent, name, venue_id, publisher

0 rows

network_screengroups

networkgroup, screengroup

0 rows

networkgroup

id, title, network

0 rows

publisher

id, name

0 rows

screen

id, title, name_publisher, building, network, venue_id

148,715 rows

screen_calc

id, name, screen, weekhour, count_plays_per_hour, length_spot_sec, raw_sample

0 rows

screengroup

id, title, grouptype, building

0 rows

screengroup_screens

screengroup, screen

Many rows

timerange

id, name

0 rows

timerange_weekhours

timerange, weekhours

0 rows

venue_taxonomy

id, name, level

0 rows

weekday

id, name

0 rows

weekday_weekhours

weekday, weekhours

0 rows

weekhour

id

0 rows