[ 'sql' => [ 1 => 'SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_47, name_1 FROM (SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.primaryport AS primaryport_3, t0_.watchdogport AS watchdogport_4, t0_.ports AS ports_5, t0_.mails AS mails_6, t0_.ordermails AS ordermails_7, t0_.topas_id AS topas_id_8, t0_.touridentifier AS touridentifier_9, t0_.touridentifierraw AS touridentifierraw_10, t0_.alternativelocation AS alternativelocation_11, t0_.alternativelocationnumber AS alternativelocationnumber_12, t0_.bundlecount AS bundlecount_13, t0_.basiowned AS basiowned_14, t0_.deliverydeactivated AS deliverydeactivated_15, t0_.basimailing AS basimailing_16, t0_.deliveryunitfactor AS deliveryunitfactor_17, t0_.maxdispotankcontent AS maxdispotankcontent_18, t0_.litercontent AS litercontent_19, t0_.tankblocked AS tankblocked_20, t0_.basidispo AS basidispo_21, t0_.sensormonitoring AS sensormonitoring_22, t0_.a1 AS a1_23, t0_.a2 AS a2_24, t0_.a3 AS a3_25, t0_.a4 AS a4_26, t0_.a5 AS a5_27, t0_.a6 AS a6_28, t0_.a7 AS a7_29, t0_.a8 AS a8_30, t0_.d1 AS d1_31, t0_.d2 AS d2_32, t0_.d3 AS d3_33, t0_.d4 AS d4_34, t0_.d5 AS d5_35, t0_.d6 AS d6_36, t0_.d7 AS d7_37, t0_.d8 AS d8_38, t0_.v1 AS v1_39, t0_.v2 AS v2_40, t0_.v3 AS v3_41, t0_.v4 AS v4_42, t0_.v5 AS v5_43, t0_.v6 AS v6_44, t0_.v7 AS v7_45, t0_.v8 AS v8_46, CASE WHEN d1_.id IS NULL THEN 1 ELSE 0 END AS sclr_47, d1_.id AS id_48, d1_.topas_id AS topas_id_49, d1_.data_number AS data_number_50, d1_.active AS active_51, t2_.id AS id_52, t2_.name AS name_53, t2_.description AS description_54, g3_.id AS id_55, g3_.name AS name_56, g3_.description AS description_57, g3_.oxaionnumber AS oxaionnumber_58, g3_.conversionfactor AS conversionfactor_59, c4_.id AS id_60, c4_.name AS name_61, c4_.customernumber AS customernumber_62, c4_.street AS street_63, c4_.zip AS zip_64, c4_.city AS city_65, c4_.contact AS contact_66, c4_.email AS email_67, c4_.phone AS phone_68, c4_.extrainfo AS extrainfo_69 FROM tank t0_ LEFT JOIN tank_type t2_ ON t0_.tanktype_id = t2_.id AND (t0_.tanktype_id = t2_.id) LEFT JOIN gas_type g3_ ON t0_.gastype_id = g3_.id AND (t0_.gastype_id = g3_.id) LEFT JOIN device d1_ ON (d1_.topas_id = t0_.topas_id) LEFT JOIN company c4_ ON d1_.company_id = c4_.id AND (d1_.company_id = c4_.id) WHERE t0_.name LIKE \'%j.con%\' OR t0_.description LIKE \'%j.con%\' OR t0_.topas_id LIKE \'%j.con%\' OR c4_.name LIKE \'%j.con%\') dctrn_result_inner ORDER BY sclr_47 ASC, name_1 ASC) dctrn_result', ], ], 'stdClass' => [ 'isMixed' => [ 2 => true, ], 'aliasMap' => [ 2 => [ 't' => 'App\\Entity\\Tank', 'd' => 'App\\Entity\\Device', 'tt' => 'App\\Entity\\TankType', 'gt' => 'App\\Entity\\GasType', 'c' => 'App\\Entity\\Company', ], ], 'relationMap' => [ 2 => [ 'tt' => 'tanktype', 'gt' => 'gastype', 'c' => 'company', ], ], 'parentAliasMap' => [ 2 => [ 'tt' => 't', 'gt' => 't', 'c' => 'd', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'description_2' => 'description', 'primaryport_3' => 'primaryport', 'watchdogport_4' => 'watchdogport', 'ports_5' => 'ports', 'mails_6' => 'mails', 'ordermails_7' => 'ordermails', 'topas_id_8' => 'topasID', 'touridentifier_9' => 'touridentifier', 'touridentifierraw_10' => 'touridentifierraw', 'alternativelocation_11' => 'alternativelocation', 'alternativelocationnumber_12' => 'alternativelocationnumber', 'bundlecount_13' => 'bundlecount', 'basiowned_14' => 'basiowned', 'deliverydeactivated_15' => 'deliverydeactivated', 'basimailing_16' => 'basimailing', 'deliveryunitfactor_17' => 'deliveryunitfactor', 'maxdispotankcontent_18' => 'maxdispotankcontent', 'litercontent_19' => 'litercontent', 'tankblocked_20' => 'tankblocked', 'basidispo_21' => 'basidispo', 'sensormonitoring_22' => 'sensormonitoring', 'a1_23' => 'A1', 'a2_24' => 'A2', 'a3_25' => 'A3', 'a4_26' => 'A4', 'a5_27' => 'A5', 'a6_28' => 'A6', 'a7_29' => 'A7', 'a8_30' => 'A8', 'd1_31' => 'D1', 'd2_32' => 'D2', 'd3_33' => 'D3', 'd4_34' => 'D4', 'd5_35' => 'D5', 'd6_36' => 'D6', 'd7_37' => 'D7', 'd8_38' => 'D8', 'v1_39' => 'V1', 'v2_40' => 'V2', 'v3_41' => 'V3', 'v4_42' => 'V4', 'v5_43' => 'V5', 'v6_44' => 'V6', 'v7_45' => 'V7', 'v8_46' => 'V8', 'id_48' => 'id', 'topas_id_49' => 'topasID', 'data_number_50' => 'dataNumber', 'active_51' => 'active', 'id_52' => 'id', 'name_53' => 'name', 'description_54' => 'description', 'id_55' => 'id', 'name_56' => 'name', 'description_57' => 'description', 'oxaionnumber_58' => 'oxaionnumber', 'conversionfactor_59' => 'conversionfactor', 'id_60' => 'id', 'name_61' => 'name', 'customernumber_62' => 'customernumber', 'street_63' => 'street', 'zip_64' => 'zip', 'city_65' => 'city', 'contact_66' => 'contact', 'email_67' => 'email', 'phone_68' => 'phone', 'extrainfo_69' => 'extrainfo', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Tank' => [ 't' => [ 'id' => 'id_0', 'name' => 'name_1', 'description' => 'description_2', 'primaryport' => 'primaryport_3', 'watchdogport' => 'watchdogport_4', 'ports' => 'ports_5', 'mails' => 'mails_6', 'ordermails' => 'ordermails_7', 'topasID' => 'topas_id_8', 'touridentifier' => 'touridentifier_9', 'touridentifierraw' => 'touridentifierraw_10', 'alternativelocation' => 'alternativelocation_11', 'alternativelocationnumber' => 'alternativelocationnumber_12', 'bundlecount' => 'bundlecount_13', 'basiowned' => 'basiowned_14', 'deliverydeactivated' => 'deliverydeactivated_15', 'basimailing' => 'basimailing_16', 'deliveryunitfactor' => 'deliveryunitfactor_17', 'maxdispotankcontent' => 'maxdispotankcontent_18', 'litercontent' => 'litercontent_19', 'tankblocked' => 'tankblocked_20', 'basidispo' => 'basidispo_21', 'sensormonitoring' => 'sensormonitoring_22', 'A1' => 'a1_23', 'A2' => 'a2_24', 'A3' => 'a3_25', 'A4' => 'a4_26', 'A5' => 'a5_27', 'A6' => 'a6_28', 'A7' => 'a7_29', 'A8' => 'a8_30', 'D1' => 'd1_31', 'D2' => 'd2_32', 'D3' => 'd3_33', 'D4' => 'd4_34', 'D5' => 'd5_35', 'D6' => 'd6_36', 'D7' => 'd7_37', 'D8' => 'd8_38', 'V1' => 'v1_39', 'V2' => 'v2_40', 'V3' => 'v3_41', 'V4' => 'v4_42', 'V5' => 'v5_43', 'V6' => 'v6_44', 'V7' => 'v7_45', 'V8' => 'v8_46', ], ], 'App\\Entity\\Device' => [ 'd' => [ 'id' => 'id_48', 'topasID' => 'topas_id_49', 'dataNumber' => 'data_number_50', 'active' => 'active_51', ], ], 'App\\Entity\\TankType' => [ 'tt' => [ 'id' => 'id_52', 'name' => 'name_53', 'description' => 'description_54', ], ], 'App\\Entity\\GasType' => [ 'gt' => [ 'id' => 'id_55', 'name' => 'name_56', 'description' => 'description_57', 'oxaionnumber' => 'oxaionnumber_58', 'conversionfactor' => 'conversionfactor_59', ], ], 'App\\Entity\\Company' => [ 'c' => [ 'id' => 'id_60', 'name' => 'name_61', 'customernumber' => 'customernumber_62', 'street' => 'street_63', 'zip' => 'zip_64', 'city' => 'city_65', 'contact' => 'contact_66', 'email' => 'email_67', 'phone' => 'phone_68', 'extrainfo' => 'extrainfo_69', ], ], ], ], 'scalarMappings' => [ 2 => [ 'sclr_47' => 'isNull', 'id_0' => 'id', ], ], 'typeMappings' => [ 2 => [ 'sclr_47' => 'string', 'id_0' => 'string', ], ], 'entityMappings' => [ 2 => [ 't' => null, 'd' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 't', 'name_1' => 't', 'description_2' => 't', 'primaryport_3' => 't', 'watchdogport_4' => 't', 'ports_5' => 't', 'mails_6' => 't', 'ordermails_7' => 't', 'topas_id_8' => 't', 'touridentifier_9' => 't', 'touridentifierraw_10' => 't', 'alternativelocation_11' => 't', 'alternativelocationnumber_12' => 't', 'bundlecount_13' => 't', 'basiowned_14' => 't', 'deliverydeactivated_15' => 't', 'basimailing_16' => 't', 'deliveryunitfactor_17' => 't', 'maxdispotankcontent_18' => 't', 'litercontent_19' => 't', 'tankblocked_20' => 't', 'basidispo_21' => 't', 'sensormonitoring_22' => 't', 'a1_23' => 't', 'a2_24' => 't', 'a3_25' => 't', 'a4_26' => 't', 'a5_27' => 't', 'a6_28' => 't', 'a7_29' => 't', 'a8_30' => 't', 'd1_31' => 't', 'd2_32' => 't', 'd3_33' => 't', 'd4_34' => 't', 'd5_35' => 't', 'd6_36' => 't', 'd7_37' => 't', 'd8_38' => 't', 'v1_39' => 't', 'v2_40' => 't', 'v3_41' => 't', 'v4_42' => 't', 'v5_43' => 't', 'v6_44' => 't', 'v7_45' => 't', 'v8_46' => 't', 'id_48' => 'd', 'topas_id_49' => 'd', 'data_number_50' => 'd', 'active_51' => 'd', 'id_52' => 'tt', 'name_53' => 'tt', 'description_54' => 'tt', 'id_55' => 'gt', 'name_56' => 'gt', 'description_57' => 'gt', 'oxaionnumber_58' => 'gt', 'conversionfactor_59' => 'gt', 'id_60' => 'c', 'name_61' => 'c', 'customernumber_62' => 'c', 'street_63' => 'c', 'zip_64' => 'c', 'city_65' => 'c', 'contact_66' => 'c', 'email_67' => 'c', 'phone_68' => 'c', 'extrainfo_69' => 'c', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Tank', 'name_1' => 'App\\Entity\\Tank', 'description_2' => 'App\\Entity\\Tank', 'primaryport_3' => 'App\\Entity\\Tank', 'watchdogport_4' => 'App\\Entity\\Tank', 'ports_5' => 'App\\Entity\\Tank', 'mails_6' => 'App\\Entity\\Tank', 'ordermails_7' => 'App\\Entity\\Tank', 'topas_id_8' => 'App\\Entity\\Tank', 'touridentifier_9' => 'App\\Entity\\Tank', 'touridentifierraw_10' => 'App\\Entity\\Tank', 'alternativelocation_11' => 'App\\Entity\\Tank', 'alternativelocationnumber_12' => 'App\\Entity\\Tank', 'bundlecount_13' => 'App\\Entity\\Tank', 'basiowned_14' => 'App\\Entity\\Tank', 'deliverydeactivated_15' => 'App\\Entity\\Tank', 'basimailing_16' => 'App\\Entity\\Tank', 'deliveryunitfactor_17' => 'App\\Entity\\Tank', 'maxdispotankcontent_18' => 'App\\Entity\\Tank', 'litercontent_19' => 'App\\Entity\\Tank', 'tankblocked_20' => 'App\\Entity\\Tank', 'basidispo_21' => 'App\\Entity\\Tank', 'sensormonitoring_22' => 'App\\Entity\\Tank', 'a1_23' => 'App\\Entity\\Tank', 'a2_24' => 'App\\Entity\\Tank', 'a3_25' => 'App\\Entity\\Tank', 'a4_26' => 'App\\Entity\\Tank', 'a5_27' => 'App\\Entity\\Tank', 'a6_28' => 'App\\Entity\\Tank', 'a7_29' => 'App\\Entity\\Tank', 'a8_30' => 'App\\Entity\\Tank', 'd1_31' => 'App\\Entity\\Tank', 'd2_32' => 'App\\Entity\\Tank', 'd3_33' => 'App\\Entity\\Tank', 'd4_34' => 'App\\Entity\\Tank', 'd5_35' => 'App\\Entity\\Tank', 'd6_36' => 'App\\Entity\\Tank', 'd7_37' => 'App\\Entity\\Tank', 'd8_38' => 'App\\Entity\\Tank', 'v1_39' => 'App\\Entity\\Tank', 'v2_40' => 'App\\Entity\\Tank', 'v3_41' => 'App\\Entity\\Tank', 'v4_42' => 'App\\Entity\\Tank', 'v5_43' => 'App\\Entity\\Tank', 'v6_44' => 'App\\Entity\\Tank', 'v7_45' => 'App\\Entity\\Tank', 'v8_46' => 'App\\Entity\\Tank', 'id_48' => 'App\\Entity\\Device', 'topas_id_49' => 'App\\Entity\\Device', 'data_number_50' => 'App\\Entity\\Device', 'active_51' => 'App\\Entity\\Device', 'id_52' => 'App\\Entity\\TankType', 'name_53' => 'App\\Entity\\TankType', 'description_54' => 'App\\Entity\\TankType', 'id_55' => 'App\\Entity\\GasType', 'name_56' => 'App\\Entity\\GasType', 'description_57' => 'App\\Entity\\GasType', 'oxaionnumber_58' => 'App\\Entity\\GasType', 'conversionfactor_59' => 'App\\Entity\\GasType', 'id_60' => 'App\\Entity\\Company', 'name_61' => 'App\\Entity\\Company', 'customernumber_62' => 'App\\Entity\\Company', 'street_63' => 'App\\Entity\\Company', 'zip_64' => 'App\\Entity\\Company', 'city_65' => 'App\\Entity\\Company', 'contact_66' => 'App\\Entity\\Company', 'email_67' => 'App\\Entity\\Company', 'phone_68' => 'App\\Entity\\Company', 'extrainfo_69' => 'App\\Entity\\Company', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [], ], ] ); }];