[ 'sql' => [ 1 => 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 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%\' ORDER BY sclr_47 ASC, t0_.name ASC) dctrn_result) dctrn_table', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\Entity\\Tank', ], ], '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', ], ], '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', ], ], ], ], 'entityMappings' => [ 2 => [ 't' => 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', ], ], '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', ], ], ], ], $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' => [], ], ] ); }];