-- Command to dump database:

-- mysqldump --complete-insert --extended-insert=FALSE --hex-blob -uroot -p appdb > text.sql

-- https://stackoverflow.com/questions/36882149/error-1067-42000-invalid-default-value-for-created-at

-- Replace "creationDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'" in the script with "`creationDate` timestamp NOT NULL,"

-- Command to import script to existing database called 'appdb'

-- mysql -uroot -pmmmmmm -D appdb < build.sql

-- Run timezons inserter Java code: ./test/com.javatmp.timezones.TestingPopulateTimezone

-- Run users inserter Java code: ./test/com.javatmp.PopulateDBFromJson

select l.`languageId` as languageId, COALESCE(t.`languageName`, l.`languageName`) as languageName

from `language` l

left OUTER JOIN languagetranslation t on t.`id` = l.`languageId` and t.`langId` = 'ar'

--left OUTER JOIN `language` d on d.`languageId` = l.`languageId`

-- https://stackoverflow.com/a/10483513/1461221

select l.`languageId`, th.`themeId`, COALESCE(t.`themeName`, th.`themeName`)

from (`language` l, `theme` th)

left OUTER JOIN themetranslation t on t.`themeId` = th.`themeId` and t.`langId` = l.`languageId`

where l.`languageId` = 'en';

select lanTr.`languageName`, t.`themeId`, coalesce(th1.themeName, th2.themeName) as col_2_0_

from `language` lan

join languagetranslation lanTr on lanTr.`languageId` = lan.`languageId` and lanTr.`langId` = lan.`languageId`

left outer join theme t on 1 = 1

left outer join themetranslation th1 on (t.themeId = th1.themeId and th1.`langId` = lan.`languageId`)

left outer join themetranslation th2 on (t.themeId = th2.themeId)

join `language` reflan on reflan.`languageId` = th2.`langId` and reflan.`isDefaultLang` = 1;

-- where t.`themeId` = 'cyborg'

;