Time Nick Message 23:50 nanu will continue tomorrow 23:50 nanu i go to the land dreams 23:47 jcamins_away But I have to go carve a duck now, so I can't look for a program to do that right now. 23:45 jcamins_away I don't know. 23:45 jcamins_away You might be able to convert bibtex to marc. 23:45 nanu so i have to add them manualy to the database? 23:44 jcamins_away nanu, not directly, no. 23:43 nanu tex or bibtex 23:23 drojf good night #koha 23:20 huginn drojf: YES! 23:20 drojf @arewethereyet 23:17 drojf or bibtex? or what? 23:17 drojf nanu: you mean tex files? 23:17 nanu . 23:16 drojf nanu: import latex? 23:08 nanu is it possible to import latex in cataloging? 23:07 nanu a little question 22:19 * cait waves 19:04 magnuse ah, of course! 19:00 jcamins_away magnuse: it's Thanksgiving! We're giving thanks! 18:51 magnuse it is - eerily silent... 18:42 tcohen guys, where r u? this is soooo silent 18:35 gaetan_B bye 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9078 normal, P5 - low, ---, tomascohen, Pushed to Master , is_holiday should honour holiday exceptions 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8800 blocker, P5 - low, ---, tomascohen, Pushed to Master , SpecifyDueDate && useDaysMode=Datedue wrong behaviour 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9064 blocker, P1 - high, ---, paul.poulain, Pushed to Master , statistics.ccode specified inconsistently 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8954 normal, P5 - low, ---, fridolyn.somers, Pushed to Master , Languages list in advanced search always in english 18:10 jenkins_koha * tomascohen: Bug 9078 - fixing exceptions broke tests 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9024 normal, P5 - low, ---, katrin.fischer, Pushed to Master , Add additional sample data to German installer 18:10 jenkins_koha * tomascohen: Bug 9078 - is_holiday should honour holiday exceptions 18:10 jenkins_koha * tomascohen: Bug 8800 - useDaysMode=Datedue wrong behaviour (revisited) 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9017 normal, P5 - low, ---, veron, Pushed to Master , Quote of the day: Table footer not translated 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9070 normal, P5 - low, ---, gmcharlt, Pushed to Master , Searching for authority from tag editor for field 650 gives error 18:10 jenkins_koha * jcamins: Bug 9064: Increment version number 18:10 jenkins_koha * Paul Poulain: Bug 9064: fix statistics.ccode column 18:10 jenkins_koha * mathieu.saby: Bug 8954: Make languages list in advanced search translatable (revision 1) 18:10 jenkins_koha * mirko: Bug 9024: Fix typo 18:10 jenkins_koha * Katrin.Fischer.83: Bug 9024: Add missing sample data to existing files 18:10 jenkins_koha * Katrin.Fischer.83: Bug 9024: Adding sample patron attributes to German web installer 18:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8844 normal, P5 - low, ---, fridolyn.somers, Pushed to Master , UNIMARC_sync_date_created_with_marc_biblio.pl creates a modification log 18:10 jenkins_koha * veron: Bug 9017 - Quote of the day: Table footer not translated 18:10 jenkins_koha * jcamins: Bug 9070: [SIGNED-OFF] authority searches in auth_finder error out 18:10 jenkins_koha * fridolyn.somers: Bug 8844: UNIMARC_sync_date_created_with_marc_biblio.pl creates a modification log 18:10 jenkins_koha Project Koha_3.10.x build #14: SUCCESS in 42 min: http://jenkins.koha-community.org/job/Koha_3.10.x/14/ 17:41 tcohen is there still a problem with the mailing lists? 17:28 jenkins_koha Starting build #14 for job Koha_3.10.x (previous build: SUCCESS) 16:03 reiveune bye 15:53 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9078 normal, P5 - low, ---, tomascohen, Pushed to Master , is_holiday should honour holiday exceptions 15:53 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8800 blocker, P5 - low, ---, tomascohen, Pushed to Master , SpecifyDueDate && useDaysMode=Datedue wrong behaviour 15:52 jenkins_koha * tomascohen: Bug 9078 - fixing exceptions broke tests 15:52 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9064 blocker, P1 - high, ---, paul.poulain, Pushed to Master , statistics.ccode specified inconsistently 15:52 jenkins_koha * tomascohen: Bug 9078 - is_holiday should honour holiday exceptions 15:52 jenkins_koha * tomascohen: Bug 8800 - useDaysMode=Datedue wrong behaviour (revisited) 15:52 jenkins_koha * jcamins: Bug 9064: Increment version number 15:52 jenkins_koha * Paul Poulain: Bug 9064: fix statistics.ccode column 15:52 jenkins_koha Project Koha_master build #948: SUCCESS in 1 hr 9 min: http://jenkins.koha-community.org/job/Koha_master/948/ 15:37 hdl_mibbit see you. 15:31 hdl_mibbit hope that helps. 15:30 hdl_mibbit maybe there is a DNS issue with koha-bugs and koha-commits. 15:30 hdl_mibbit So... 15:30 hdl_mibbit The latest messages I found were received yesterday 15:29 hdl_mibbit jcamins_away: fwiw, i searched koha-bugs and koha-commits logs. 15:29 hdl_mibbit hi 15:09 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9049 normal, P5 - low, ---, gmcharlt, Signed Off , rebuild_zebra should not use shadow when called with -r 15:09 wajasu bug 9049 is a no-brainer for qa 15:07 wajasu ok 9049 signed-off 15:00 jcamins_away Happy Thanksgiving! 15:00 * jcamins_away leaves again 14:49 paul_p_ thx jcamins_away ! 14:46 jcamins_away I see, yeah. 14:46 kf hm I think it's also on the basket summary page on top - you can't close a basket as long as you have uncertain prices 14:46 jcamins_away Thanks. 14:46 jcamins_away Ah-ha. 14:46 kf in the last pulldown I think is the uncertain prices page 14:46 kf go to the vendor 14:46 kf check the 'uncertain price' checkbox 14:46 jcamins_away Okay. 14:46 kf jcamins_away: create an order 14:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9106 critical, P5 - low, ---, koha-bugs, Passed QA , Filtering list of uncertain price list by owner empties order information 14:45 kf bug 9106 14:45 tcohen jcamins_away++ and paul_p++! 14:45 jcamins_away It's 9106 that I can't figure out. 14:45 kf thx 14:45 kf ah great 14:45 kf 9078 - it's hidden in the comments 14:45 jcamins_away kf: I pushed both. 14:45 huginn New commit(s) kohagit: Bug 9078 - fixing exceptions broke tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=afc860d66bd706a80fe1b6404b648aa4592f3f79> / Bug 9078 - is_holiday should honour holiday exceptions <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8615996749d84c1b54327d74aec2dd423650a4f5> 14:45 kf jcamins_away: the patch paul qa'd - sorry I forgot to note more explicitly that I tested them together 14:45 wahanui patch is pretty old now, good luck 14:45 jcamins_away What patch? 14:44 kf jcamins_away: the due date blocker bug will not work without this patch 14:43 jenkins_koha Starting build #948 for job Koha_master (previous build: SUCCESS) 14:41 jcamins_away Where is the uncertain orders page? 14:39 paul_p_ yikes ! you're right... OK, will send a mail to our sysop immediately 14:38 jcamins_away Okay, and 9106 passed QA. 14:37 jcamins_away Both stopped sending e-mail yesterday. 14:37 jcamins_away koha-bugs and koha-commits. 14:36 paul_p_ is it just you ? from all mailing lists (koha-devel / koha-translate / ...) ? have you checked you've subscribed ? 14:36 jcamins_away paul_p_: I'm not getting any e-mail. 14:35 huginn New commit(s) kohagit: Merge branch 'bug_8800' into 3.12-master <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f7fabc661cbd7ba1a79e4e1e93911316714e3d68> / Bug 8800 - useDaysMode=Datedue wrong behaviour (revisited) <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7b18e2146cbb1f4d0f9a87002e5ec8580bc188d6> / Bug 9064: Increment version number <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=64b9bc74b 14:34 paul_p_ jcamins_away = nope. what kind of problem? 14:34 jcamins_away paul_p_: has it been reported to you that there seems to be a problem with the mailing lists? 14:33 jcamins_away Okay, I'll take a look. 14:33 paul_p_ jcamins_away = bug 9078 passed QA 14:29 jcamins_away Thanks. 14:29 paul_p_ OK, will QA NOW then ! 14:29 jcamins_away Hours, almost certainly not. 14:29 jcamins_away Minutes, maybe. 14:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9078 normal, P5 - low, ---, tomascohen, Signed Off , is_holiday should honour holiday exceptions 14:29 paul_p_ jcamins_away = I have to QA another one -bug 9078 - will you be around in a few minuts/hours ? 14:28 jcamins_away paul_p_: I pushed the two blockers to master. 14:13 wahanui well, irspy is a good source for identifying Z39.50 targets. See http://irspy.indexdata.com. 14:13 kf irspy? 14:13 wahanui z39.50 is the ANSI standard of the beast. 14:13 kf z39.50? 14:07 jcamins_away oleonard: probably. 14:06 * oleonard is pondering whether going to the grocery store on Thanksgiving morning is a crazy idea 14:05 oleonard And my family doesn't arrive until Saturday, so I'm doing whatever I want :P 14:05 oleonard Thanks jcamins_away, it works fine in the ByWater demo too. I guess something is messed up in this installation 14:05 * mveron has a minute between two meetings to share the following: http://vimeo.com/53679084 Hmm, we should implement Biblio-Mat in Koha :-) 14:04 jcamins_away oleonard: and MARC view works fine for me. 14:03 jcamins_away oleonard: Happy Thanksgiving, go spend time with your family. :P 14:00 kf drojf: nanu is from austria 14:00 jcamins_away vfernandes: the MARC editor is awful, and doesn't handle subfield order, but unfortunatley there's no way to fix it. 14:00 kf drojf: you ate all the cookies? 13:59 jcamins_away Happy Thanksgiving. 13:59 * drojf accidentally the whole pack of cookies 13:57 nanu thank you 13:57 nanu thank you 13:57 nanu everything is so nice 13:57 nanu i like you 13:56 jcamins_away wajasu: BibLibre had an authority generator script at some point, but I don't think it was ever updated to work with Zebra. 13:56 drojf hi kf 13:56 kf hi drojf 13:55 drojf deutsch? bin ich falsch abgebogen? 13:55 kf nanu: vermutlich ist zebra nicht richtig eingerichtet 13:55 wahanui search faq is http://koha-community.org/documentation/faq/ 13:55 kf search faq? 13:54 drojf hi #koha 13:45 nanu http://nuss.buch.diemultiversitaet.org/cgi-bin/koha/opac-search.pl?idx=kw&q=kolland&idx=kw&idx=kw&do=Suche&sort_by=relevance 13:45 nanu http://nuss.buch.diemultiversitaet.org/cgi-bin/koha/opac-detail.pl?biblionumber=4 13:45 nanu the 2 testlinks 13:45 nanu i have sucessfully added an item but in the search i cant find the book 13:44 nanu one more question 13:41 tcohen (MPL branch is used in several places) 13:40 tcohen right now, they were being used as sample data for the tests 13:38 tcohen i agree 13:38 kf tcohen: I agree about test data - I only wonder if the web installer files are the right palce 13:36 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9133 normal, P5 - low, ---, gmcharlt, NEW , We need a data set for db dependent tests 13:36 tcohen kf: bug 9133 13:34 oleonard I get a blank page. 13:32 oleonard On this machine the MARC view in the staff client seems to be broken in master and 3.8.x. Can anyone confirm? 13:32 tcohen if my first question is answered 'yes' 13:31 tcohen after working in this patch i belive we might need to have a test data set for testing purposes 13:31 tcohen i'll wait for those responses on the list 13:30 kf and removes it after running the test? or mock it? 13:30 kf tcohen: would it be possible that your test adds the data to the database? 13:30 kf tcohen: it's the calandar mess all over again 13:30 kf tcohen: I don't know it :( 13:29 tcohen i'm not sure when was the 'all libraries'/empty holiday definition removed 13:28 tcohen and an updatedatabase script that fixes that for working libraries 13:28 tcohen we might need to fill a new bug for removing those branch-less holiday definitions 13:27 tcohen kf: i sent an email to the koha-dev list regarding this, i'm not sure how to deal with this 13:26 kf and tcohen: in sample libraries yes - but not in the other holiday data - so I got confused what you meatn 13:26 kf I hve opened a private chat with you in german :) 13:26 kf nanu: are you usig mibbit? 13:25 nanu is no working to 13:25 nanu that with the umlaute 13:25 nanu kf yes 13:25 kf kf: in sample libraries yes - but not in the other holiday data - so I got confused what you meatn 13:24 tcohen s/sqk/sql/ 13:24 tcohen kf: bracause the MPL branch is there, in the sample_libreries.sqk 13:24 kf nanu: you sepak german? :) 13:23 kf tcohen: I wondered because the patch still included de-DE 13:22 kf sorry - back 13:13 gaetan_B sometimes when you import records via z39.50 or via the import tool, you'll get this problem because you selected the wrong encoding. Ask you provider which encoding the files are in, and make sure the parameteres are right for the z39.50 server you are querying or the import you are doing. 13:11 gaetan_B it should be fine normally 13:11 gaetan_B where did the record with those characters came from ? 13:11 gaetan_B this probably depends on the machine you are using 13:10 nanu how can i use ÜÖÄ in the titles of the books and not a� 13:09 nanu and one more question 13:09 nanu it is at the moment also a game to understand koha 13:08 nanu i dont know why the university of vienna is using another mapping 13:07 nanu I am using an now empty database 13:07 nanu iit 13:07 nanu i got 13:07 nanu okey 13:06 gaetan_B now, where are my cookies? :p 13:05 gaetan_B i've never done it on a system that already had bibliographic records 13:05 gaetan_B you probably want to do it when your database is empty actually 13:05 gaetan_B but as kf said, don't do this lightheartedly, it's a decision you should have carefully thougth through before you proceed 13:04 gaetan_B so that you will modify the mapping everywhere and not just on one framework 13:04 gaetan_B nanu: there are two ways to change the koha to marc mappings, either on the framework itself in the added constraint of your subfield, or in administration under koha to MARC mappings. My suggestion would be, never use the first option and always use the dedicated tool to do this 12:52 huginn nanu: I'll give you the answer as soon as RDA is ready 12:52 nanu @kf but the main university in austria is using other mappings 12:51 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9074 normal, P5 - low, ---, tomascohen, Signed Off , DB dependent tests for is_holiday 12:50 tcohen kf,khall, i recreated patch for bug 9074, removing sample holidays for languages that don't have the MPL branch in the sample data 12:47 tcohen kf, ping 12:47 tcohen morning #koha 12:46 wahanui "What are you trying to do?" or "What is the goal?" 12:46 kf first question? 12:46 kf there is lots of functionality tied to them, so it's dangerous 12:46 kf not light heartedly 12:46 kf nanu: you shouldn't change the marc mappings 12:46 kf oh i missed the cookies 12:43 nanu or database table? 12:42 nanu or in which file can i change the marc-framework used there? 12:41 nanu how can i use my own marc framework for the koha to marc mapping? 12:37 * Oak puts cookies back in the closet 12:36 nanu mhm 12:36 * Oak offers kf cookies 12:34 kf nanu: what do you want to do? 12:32 nanu ? 12:29 nanu how can i use my self modified marc in the koha to marc mapping 12:24 kf tcohen: around? 12:11 wajasu just ask. 12:07 y1s4d3 any one help me......? 12:06 y1s4d3 hiiiiiii 11:40 newa34 thanx all 11:40 newa34 thank u all..i was doing in wrong way ....i got it now 11:37 wajasu new34a: you are going to have to run the script from the command line. be sure to set your KOHA_CONF and PERL5LIB environment variables accordingly. and repeatedly run the fix_accountline_rmdupfines_bug8253.pl until it doesn't find any dups. 11:24 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8253 critical, P1 - high, ---, kyle.m.hall, Pushed to Stable , fix fine doubling, when upgrading from 3.6 to 3.8 (or later) 11:24 mtj newa34, the fix for your problem (bug 8253) was included in koha 3.8.7 11:22 newa34 file 11:22 newa34 rangi gave some idea last time...misc_maintenance_fix_accountlines_rmdupfines_bug8253.pl but i dnt know how to get it use. 11:18 wajasu i am not sure, but i can faintly recall that there might have been a field holding a timestamp that is now to the minute, and maybe its a duplicate row. someone else might know. 11:07 newa34 when i manually export/import the database of accountlines tables on new version and run the fine.pl script it addup the amount again 11:05 newa34 installed 3.08.07 ..configured all the settings and tried to generated fine ...its ok perfectly... but i have older version of koha 3.04.04 and i need to transfer all the issues and accountlines to newer version 11:03 newa34 :( 11:03 newa34 i am still having trouble with fine charge ... 11:01 magnuse hello newa34 10:44 newa34 hello 10:26 vfernandes i'll tell them to use the move up button... I think it works fine 10:25 wajasu and since you can have multipl heading per biblio, you can get mulitple auth records. 10:25 vfernandes they can always use the move up button 10:25 vfernandes magnuse 10:25 magnuse vfernandes: ah, ok 10:24 wajasu so if i catalog multiple books by 'Calvin, Jean', I get duplicate authority records generated, unless I wait 5 minutes for zebra to index. 10:22 vfernandes magnuse that's not my problem... my problem is with subfields order 10:20 wajasu doesn't anyone auto generate authorites? it seems like it might have worked with 'NoZebra' at one point, but now it generates a new authority record for each biblio's heading since the authority search won't ever find a newly created auth until its indexed (5 min). 10:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7882 enhancement, P5 - low, ---, elliott, Failed QA , move or reorder 6xx and 7xx fields 10:20 magnuse bug 7882 10:15 vfernandes the problem is more important when you clone a field 10:08 vfernandes the bug isn't that... 10:07 vfernandes I think ordering is necessary... 2 clients need this done :/ 10:06 huginn 04Bug 8976: enhancement, P1 - high, ---, gmcharlt, NEW , Sequence of subfield in Editor 10:06 vfernandes maybe http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8976 10:06 kf I think always ordering would not be right as changing the order seems to be a feature 10:05 kf there is abug about ordering/reordering subfields somewhere in bugzilla I think 10:05 kf vfernandes: I am not sure about this 10:05 vfernandes and even in the normal design 10:04 vfernandes I think that the subfields should be always ordered, because it affects the way that the record it's present using XSLT 10:02 vfernandes for example if I have a 606$a filled and a 606$6 filled when the field is expanded, the subfields aren't ordered 10:01 vfernandes i've detected a bug (in my opinion) on modifying biblio 10:01 vfernandes hi guys 09:31 kf hi magnuse and marcelr 09:27 magnuse hiya Irma, if you are really here ;-) 09:27 magnuse hiya marcelr 09:26 marcelr hi kf & magnuse 09:25 magnuse kia ora kf 09:03 kf good morning #koha 08:36 tweetbot` [off] twitter: @kohails: "#kohails Koha 3.8.7 Released http://t.co/ihlVb64S" 08:21 marcelr hi rangi 08:21 rangi hi paul_p and marcelr 08:21 marcelr hi paul_p 08:20 paul_p good morning everybody 08:19 marcelr hi #koha 08:07 jenkins_koha * Chris Cormack: Release notes and bumping version for release 08:07 jenkins_koha * f.demians: 3.8.7 Translation Update 08:07 jenkins_koha Project Koha_3.8.x build #230: SUCCESS in 38 min: http://jenkins.koha-community.org/job/Koha_3.8.x/230/ 08:03 rangi hi gaetan_B 08:02 gaetan_B hello 07:56 magnuse nice 07:55 rangi right fixed awstats too, so will get better stats of downloads 07:51 alex_a hello rangi ! 07:49 reiveune hello 07:45 rangi hi alex_a 07:43 wahanui niihau, alex_a 07:43 alex_a bonjour 07:41 Oak \o/ 07:41 Oak rangi++ 07:40 magnuse rangi++ 07:37 rangi there we go 07:33 magnuse yup 07:31 rangi so that 3.10.0 is given the last word (for a month or so) 07:30 rangi yeah probably better to do it first 07:30 magnuse rangi: get it out there, i'd say :-) 07:29 jenkins_koha Starting build #230 for job Koha_3.8.x (previous build: SUCCESS) 07:28 rangi i wonder when paul is planning for 3.10.0 07:28 rangi hmm i have 3.8.7 all ready to go 07:27 * druthb wanders off to bed. 07:15 Oak :-) 07:14 * druthb gives huginn the ebil eye 07:14 huginn druthb: One would be wise to think so. 07:14 druthb @eightball will Oak manage to drop my power? 07:14 magnuse w00t! 07:14 huginn magnuse: YES! 07:14 magnuse @arewethereyet 07:13 * magnuse perks up at the mention of linked data 07:13 Oak you leave us no choice 07:13 Oak hmm. i'll send someone to cut your electricity now 07:13 druthb 01:12. 07:12 Oak night owl 07:12 Oak ah yes seriously... it may be like 2am-ish there 07:12 druthb :P 07:12 cait and go to bed druthb :) 07:12 Oak :) 07:12 wahanui Well, she finally snapped, like we all knew she would. 07:12 druthb wahanui: druthb? 07:12 cait hi oak 07:12 druthb oh, lookie! There's Oak! 07:11 wahanui i already had it that way, Oak. 07:11 Oak oh look druthb is here 07:11 Oak cait :) 07:08 rangi evening 06:36 cait 3 weeks can feel pretty short :) 06:33 cait hope it will good, updating libraries today 06:27 cjh heh only 3 weeks :p 06:27 cjh oh awesome, hope you have an awesome day at work :) 06:26 cait back the second week now 06:26 cait getting ready for work 06:26 cait it was 'only' 3 weeks 06:25 cait ah it's over 06:25 cjh is your 'holiday' still going, or did I miss it's finish? 06:24 cait oh cool 06:24 cjh although I didnt go to work today, instead I was at THATcamp learning about linked data :) 06:24 cait ah good :) 06:24 cjh no, at home about to make dinner. 06:23 cait still at work? 06:23 cait hi cjh 06:23 cjh good... evening :) 06:23 cait good morning #koha 05:20 Oak magnuse 05:20 Oak Ahoy me hearties 03:27 wajasu that script is useless for generating auth records. since for each auth record it creates, the zebra index hasn't been rebuilt, so it creates another because there are never any matches. 03:25 wajasu shoot i tried to select nozebra to maybe get link_bibs_to_authorities to work, but alas only zebra or solr for master. 00:03 tcohen_home the russian derivatives have, but different branch ids 00:03 tcohen_home it-IT and fr-FR don't have sample branches 00:01 * tcohen_home still thinks what to do with the inconsistency between languages regarding sample SQL data