#query that is making MariaDB crash
select count(distinct uid_foreign) as nb,sys_category.title,sys_category.uid from sys_category_record_mm
                        left join sys_category on sys_category_record_mm.uid_local = uid
                        right join (  select * from (select 'tx_cimassociation_domain_model_association' as type,'9' as content_element_id,uid,hidden,deleted,starttime,endtime,(SELECT concat(',',concat(GROUP_CONCAT(distinct category.uid SEPARATOR ','),',')) FROM `sys_category` category left join sys_category_record_mm on category.uid = uid_local where sys_category_record_mm.uid_foreign = tx_cimassociation_domain_model_association.uid and tablenames ='tx_cimassociation_domain_model_association') as category_stringM, '' as crdate, '' as tstamp, '' as teaser,title, '' as bodytext, '' as datetime, '' as istopnews, '' as cim_news_start_date, '' as cim_news_end_date,pid, '' as archive,map_longitude,map_latitude, '' as cim_base_desc_page,description,private_element,type_element,(SELECT GROUP_CONCAT(distinct sys_file.identifier SEPARATOR ',') FROM `sys_file_reference` inner join sys_file on sys_file_reference.uid_local=sys_file.uid where tablenames = 'tx_cimassociation_domain_model_association' and fieldname = 'picture' and tx_cimassociation_domain_model_association.uid = uid_foreign and sys_file_reference.deleted = 0 and sys_file_reference.hidden = 0 ) as media,address,telephone,permanences,website,schedule,(SELECT GROUP_CONCAT(distinct sys_file.identifier SEPARATOR ',') FROM `sys_file_reference` inner join sys_file on sys_file_reference.uid_local=sys_file.uid where tablenames = 'tx_cimassociation_domain_model_association' and fieldname = 'kml_file' and tx_cimassociation_domain_model_association.uid = uid_foreign and sys_file_reference.deleted = 0 and sys_file_reference.hidden = 0 ) as kml_file, '' as mapgenerator_value, '' as link, '' as libelle, '' as reponse, '' as budget,email, '' as element, '' as item_uid, '' as fe_user, '' as contributes, '' as experts from tx_cimassociation_domain_model_association) as tableElement  where 1=1  and hidden = 0 and deleted = 0 and starttime<=1450279411 AND (endtime=0 OR endtime>1450279411)  and pid IN (126)  AND type_element = 5 UNION select * from (select 'pages' as type,'13' as content_element_id,uid,hidden,deleted,starttime,endtime,(SELECT concat(',',concat(GROUP_CONCAT(distinct category.uid SEPARATOR ','),',')) FROM `sys_category` category left join sys_category_record_mm on category.uid = uid_local where sys_category_record_mm.uid_foreign = pages.uid and tablenames ='pages') as category_stringM, '' as crdate, '' as tstamp, '' as teaser,title, '' as bodytext, '' as datetime, '' as istopnews, '' as cim_news_start_date, '' as cim_news_end_date,pid, '' as archive,map_longitude,map_latitude, '' as cim_base_desc_page,(SELECT content FROM `tx_kesearch_index` where orig_uid=pages.uid and type = 'page') as description, '' as private_element, '' as type_element, '' as media, '' as address, '' as telephone, '' as permanences, '' as website, '' as schedule, '' as kml_file, '' as mapgenerator_value, '' as link, '' as libelle, '' as reponse, '' as budget, '' as email, '' as element, '' as item_uid, '' as fe_user, '' as contributes, '' as experts from pages) as tableElement  where 1=1  and hidden = 0 and deleted = 0 and starttime<=1450279411 AND (endtime=0 OR endtime>1450279411)  and pid IN (167,214,152,232,15,151,12,13,16,14,217,160,156,157,168,220,221,222,223,224,225,236,146,144,142,115,113,137,9,6,261,262,263,264,265,266,267,268,257,258,259,260,252,253,254,255,256,52,53,54,55,56,247,248,249,250,242,251,243,245,246,48,49,50,296,297,298,299,300,292,293,294,295,282,283,284,285,286,287,288,289,290,291,278,279,280,281,276,277,269,270,271,272,273,274,275,41,42,44,238,46,47,200,201,202,203,36,37,38,39,40,196,197,198,172,173,174,175,176,177,178,179,180,181,140,164,131,189,193,192,195,29,239,241,240,237,30,158,139,33,149,35,24,25,26,27,28,4,5,8,136,112,114,141,143,234,235,154,166,219,7,155,11,19,21,20,135,3,10,111,148,161,150,169,233,165,218,227,18,22,2,147,1)  ORDER BY RAND()) as groupedTable  on uid_foreign = groupedTable.uid and tablenames = groupedTable.type
                        group by sys_category_record_mm.uid_local order by 1 desc
						
#syslog output
Dec 16 18:14:48 wdevl01 mysqld: 151216 18:14:48 [ERROR] mysqld got signal 11 ;
Dec 16 18:14:48 wdevl01 mysqld: This could be because you hit a bug. It is also possible that this binary
Dec 16 18:14:48 wdevl01 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Dec 16 18:14:48 wdevl01 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: We will try our best to scrape up some info that will hopefully help
Dec 16 18:14:48 wdevl01 mysqld: diagnose the problem, but since we have already crashed,
Dec 16 18:14:48 wdevl01 mysqld: something is definitely wrong and this may fail.
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: Server version: 10.1.9-MariaDB-1~jessie-log
Dec 16 18:14:48 wdevl01 mysqld: key_buffer_size=134217728
Dec 16 18:14:48 wdevl01 mysqld: read_buffer_size=2097152
Dec 16 18:14:48 wdevl01 mysqld: max_used_connections=4
Dec 16 18:14:48 wdevl01 mysqld: max_threads=102
Dec 16 18:14:48 wdevl01 mysqld: thread_count=1
Dec 16 18:14:48 wdevl01 mysqld: It is possible that mysqld could use up to
Dec 16 18:14:48 wdevl01 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759822 K  bytes of memory
Dec 16 18:14:48 wdevl01 mysqld: Hope that's ok; if not, decrease some variables in the equation.
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: Thread pointer: 0x0x32b90ebb008
Dec 16 18:14:48 wdevl01 mysqld: Attempting backtrace. You can use the following information to find out
Dec 16 18:14:48 wdevl01 mysqld: where mysqld died. If you see no messages after this, something went
Dec 16 18:14:48 wdevl01 mysqld: terribly wrong...
Dec 16 18:14:48 wdevl01 mysqld: stack_bottom = 0x32bbb6d3df8 thread_stack 0x48000
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x1165f19b6e]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x34d)[0x1165a5ed6d]
Dec 16 18:14:48 wdevl01 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x32bbb3798d0]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(+0x936ada)[0x1165dfaada]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z15end_read_recordP11READ_RECORD+0x8e)[0x1165b5619e]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN13st_join_table7cleanupEv+0x147)[0x1165918e97]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN4JOIN7cleanupEb+0xc8)[0x116591e248]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN4JOIN7destroyEv+0x155)[0x116591e8b5]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN13st_select_lex7cleanupEv+0x28)[0x1165971e38]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN18st_select_lex_unit7cleanupEv+0xd6)[0x1165971fe6]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z18mysql_derived_fillP3THDP3LEXP10TABLE_LIST+0x10b)[0x11658b490b]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xdc)[0x11658b5b4c]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN13st_join_table12preread_initEv+0xd0)[0x116590f960]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x306)[0x116590fdd6]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(+0x45ad95)[0x116591ed95]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x900)[0x11659313f0]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x54)[0x1165933544]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xfd)[0x116592fd0d]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x11659306e1]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(+0x40b8f1)[0x11658cf8f1]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6005)[0x11658db935]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20e)[0x11658dedbe]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1f4a)[0x11658e1b3a]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x16e)[0x11658e238e]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x182)[0x11659aab72]
Dec 16 18:14:48 wdevl01 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x11659aad30]
Dec 16 18:14:48 wdevl01 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x32bbb3720a4]
Dec 16 18:14:48 wdevl01 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x32bb951e04d]
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: Trying to get some variables.
Dec 16 18:14:48 wdevl01 mysqld: Some pointers may be invalid and cause the dump to abort.
Dec 16 18:14:48 wdevl01 mysqld: Query (0x32b8fc9d020): is an invalid pointer
Dec 16 18:14:48 wdevl01 mysqld: Connection ID (thread ID): 543
Dec 16 18:14:48 wdevl01 mysqld: Status: NOT_KILLED
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
Dec 16 18:14:48 wdevl01 mysqld: 
Dec 16 18:14:48 wdevl01 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Dec 16 18:14:48 wdevl01 mysqld: information that should help you find out what is causing the crash.
Dec 16 18:14:49 wdevl01 mysqld_safe: Number of processes running now: 0
Dec 16 18:14:49 wdevl01 mysqld_safe: mysqld restarted
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] /usr/sbin/mysqld (mysqld 10.1.9-MariaDB-1~jessie-log) starting as process 20540 ...
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: The InnoDB memory heap is disabled
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Memory barrier is not used
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Compressed tables use zlib 1.2.8
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Using Linux native AIO
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Not using CPU crc32 instructions
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Initializing buffer pool, size = 256.0M
Dec 16 18:14:49 wdevl01 mysqld: 2015-12-16 18:14:49 2812574513088 [Note] InnoDB: Completed initialization of buffer pool
Dec 16 18:14:50 wdevl01 mysqld: 2015-12-16 18:14:50 2812574513088 [Note] InnoDB: Highest supported file format is Barracuda.
Dec 16 18:14:50 wdevl01 mysqld: 2015-12-16 18:14:50 2812574513088 [Note] InnoDB: Log scan progressed past the checkpoint lsn 131448836677
Dec 16 18:14:50 wdevl01 mysqld: 2015-12-16 18:14:50 2812574513088 [Note] InnoDB: Database was not shutdown normally!
Dec 16 18:14:50 wdevl01 mysqld: 2015-12-16 18:14:50 2812574513088 [Note] InnoDB: Starting crash recovery.
Dec 16 18:14:50 wdevl01 mysqld: 2015-12-16 18:14:50 2812574513088 [Note] InnoDB: Reading tablespace information from the .ibd files...
Dec 16 18:15:06 wdevl01 mysqld: 2015-12-16 18:15:06 2812574513088 [Note] InnoDB: Processed 1771 .ibd/.isl files
Dec 16 18:15:22 wdevl01 mysqld: 2015-12-16 18:15:22 2812574513088 [Note] InnoDB: Processed 4015 .ibd/.isl files
Dec 16 18:15:26 wdevl01 mysqld: 2015-12-16 18:15:26 2812574513088 [Note] InnoDB: Restoring possible half-written data pages
Dec 16 18:15:26 wdevl01 mysqld: 2015-12-16 18:15:26 2812574513088 [Note] InnoDB: from the doublewrite buffer...
Dec 16 18:15:27 wdevl01 mysqld: InnoDB: Doing recovery: scanned up to log sequence number 131449873954
Dec 16 18:15:27 wdevl01 mysqld: InnoDB: Transaction 158707045 was in the XA prepared state.
Dec 16 18:15:27 wdevl01 mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up
Dec 16 18:15:27 wdevl01 mysqld: InnoDB: in total 0 row operations to undo
Dec 16 18:15:27 wdevl01 mysqld: InnoDB: Trx id counter is 158707456
Dec 16 18:15:27 wdevl01 mysqld: 2015-12-16 18:15:27 2812574513088 [Note] InnoDB: Starting an apply batch of log records to the database...
Dec 16 18:15:28 wdevl01 mysqld: InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
Dec 16 18:15:28 wdevl01 mysqld: InnoDB: Apply batch completed
Dec 16 18:15:28 wdevl01 mysqld: InnoDB: Last MySQL binlog file position 0 76617545, file name /var/log/mysql/mariadb-bin.000388
Dec 16 18:15:29 wdevl01 pure-ftpd: (?@109.190.198.179) [INFO] New connection from 109.190.198.179
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] InnoDB: 128 rollback segment(s) are active.
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] InnoDB: Waiting for purge to start
Dec 16 18:15:29 wdevl01 mysqld: InnoDB: Starting in background the rollback of uncommitted transactions
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 28eafb19700  InnoDB: Rollback of non-prepared transactions completed
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 131449873954
Dec 16 18:15:29 wdevl01 pure-ftpd: (?@109.190.198.179) [INFO] cimeos-barleduc is now logged in
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2811768940288 [Note] InnoDB: Dumping buffer pool(s) not yet started
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Plugin 'FEEDBACK' is disabled.
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Recovering after a crash using /var/log/mysql/mariadb-bin
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Starting crash recovery...
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 28eda8137c0  InnoDB: Starting recovery for XA transactions...
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 28eda8137c0  InnoDB: Transaction 158707045 in prepared state after recovery
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 28eda8137c0  InnoDB: Transaction contains changes to 1 rows
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 28eda8137c0  InnoDB: 1 transactions in prepared state after recovery
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Found 1 prepared transaction(s) in InnoDB
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Crash recovery finished.
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Server socket created on IP: '127.0.0.1'.
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Reading of all Master_info entries succeded
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] Added new Master_info '' to hash table
Dec 16 18:15:29 wdevl01 mysqld: 2015-12-16 18:15:29 2812574513088 [Note] /usr/sbin/mysqld: ready for connections.
Dec 16 18:15:29 wdevl01 mysqld: Version: '10.1.9-MariaDB-1~jessie-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution