#Toast titanium 9.0 1 serial
#Toast titanium 9.0 1 plus

‘unit-testing’ a relation to almost every column here, except to ‘php’, ‘html’, ‘css’, and ‘jquery’.

‘multi-threading’ shows a relation to ‘python’, ‘java’, ‘c#’, and ‘android`.

‘machine-learning’ shows a relation to ‘python’, but not the other way around.

‘javascript’ shows a relation to ‘php’, ‘html’, ‘css’, ‘node.js’, and ‘jquery’.

What you see here is a co-occurrence matrix: Let’s see first a subset of these results: Then I can use that string to get a huge table, with a 1 for every time a tag co-occurs with the main one at least certain % of time. So I’m going to create a string first that will define all the columns where I want to find co-occurrence. BigQuery ML does a good job of hot-encoding strings, but it doesn’t handle arrays as I wish it did (stay tuned). CREATE OR REPLACE TABLE `deleting.stack_overflow_tag_co_ocurrence`ASWITH data AS ( SELECT * FROM `fh-bigquery.stackoverflow_archive.201906_posts_questions` WHERE creation_date > ''), active_tags AS ( SELECT tag, COUNT(*) c FROM data, UNNEST(SPLIT(tags, '|')) tag GROUP BY 1 HAVING c>180)SELECT *, questions/questions_tag1 percentFROM ( SELECT *, MAX(questions) OVER(PARTITION BY tag1) questions_tag1 FROM ( SELECT tag1, tag2, COUNT(*) questions FROM data, UNNEST(SPLIT(tags, '|')) tag1, UNNEST(SPLIT(tags, '|')) tag2 WHERE tag1 IN (SELECT tag FROM active_tags) AND tag2 IN (SELECT tag FROM active_tags) GROUP BY 1,2 HAVING questions>30 ))

#Toast titanium 9.0 1 plus

So I’ll take these relationships and I’ll save them on an auxiliary table - plus a percentage of how frequently a relationship happens for each tag.

Let’s find tags that usually go together:

#Toast titanium 9.0 1 serial

Serial ATA Device: WDC WD6400AAKS-00A7B0, 596.# Tags with >180 questions since 2018SELECT tag, COUNT(*) questionsFROM `fh-bigquery.stackoverflow_archive.201906_posts_questions`, UNNEST(SPLIT(tags, '|')) tagWHERE creation_date > ''GROUP BY 1HAVING questions>180ORDER BY 2 DESC Hint: Co-occurring tags Memory Module: Bank6/7/A3, 2 GB, RAM, 800 MHzĪirPort: spairport_wireless_card_type_third_partyīluetooth: Version 2.1.0f17, 2 service, 1 devices, 1 incoming serial ports Memory Module: Bank4/5/A2, 2 GB, RAM, 800 MHz Memory Module: Bank2/3/A1, 2 GB, RAM, 800 MHz Memory Module: Bank0/1/A0, 2 GB, RAM, 800 MHz Graphics: kHW_ATIr520Item, ATY,RadeonX1600, spdisplays_pcie_device, 512 MB Model: EP45-DS3R, BootROM 00, 4 processors, 2.4 GHz, 8 GB *** -: attempt to insert nil value (key: VMUSignaturePath) Path: /Applications/Toast 9 Titanium/Toast Titanium.app/Contents/MacOS/Toast TitaniumĮxception Codes: KERN_PROTECTION_FAILURE at 0x0000000007885ff0 Restarted computer, tried different blank DVD-R, re-installed Toast. Went to copy more DVDs today and it stopped working again. I was having this problem at first, then all of the sudden it just worked. I have successfully burnt two DVDs this way. I click the big red button and it shrinks to the Waiting percentage bar, sits at 0% for 2 seconds then errors and shuts down Toast. I make sure to check 'Fit-to-DVD video compression'.

Then I take the VIDEO_TS folder and drag it into Toast (Video -> Video_TS folders).