object(Drupal\Core\Database\Statement)#1371 (3) { ["dbh"]=> object(Drupal\Core\Database\Driver\mysql\Connection)#19 (22) { ["needsCleanup":protected]=> bool(false) ["reservedKeyWords":"Drupal\Core\Database\Driver\mysql\Connection":private]=> array(263) { [0]=> string(10) "accessible" [1]=> string(3) "add" [2]=> string(5) "admin" [3]=> string(3) "all" [4]=> string(5) "alter" [5]=> string(7) "analyze" [6]=> string(3) "and" [7]=> string(2) "as" [8]=> string(3) "asc" [9]=> string(10) "asensitive" [10]=> string(6) "before" [11]=> string(7) "between" [12]=> string(6) "bigint" [13]=> string(6) "binary" [14]=> string(4) "blob" [15]=> string(4) "both" [16]=> string(2) "by" [17]=> string(4) "call" [18]=> string(7) "cascade" [19]=> string(4) "case" [20]=> string(6) "change" [21]=> string(4) "char" [22]=> string(9) "character" [23]=> string(5) "check" [24]=> string(7) "collate" [25]=> string(6) "column" [26]=> string(9) "condition" [27]=> string(10) "constraint" [28]=> string(8) "continue" [29]=> string(7) "convert" [30]=> string(6) "create" [31]=> string(5) "cross" [32]=> string(4) "cube" [33]=> string(9) "cume_dist" [34]=> string(12) "current_date" [35]=> string(12) "current_time" [36]=> string(17) "current_timestamp" [37]=> string(12) "current_user" [38]=> string(6) "cursor" [39]=> string(8) "database" [40]=> string(9) "databases" [41]=> string(8) "day_hour" [42]=> string(15) "day_microsecond" [43]=> string(10) "day_minute" [44]=> string(10) "day_second" [45]=> string(3) "dec" [46]=> string(7) "decimal" [47]=> string(7) "declare" [48]=> string(7) "default" [49]=> string(7) "delayed" [50]=> string(6) "delete" [51]=> string(10) "dense_rank" [52]=> string(4) "desc" [53]=> string(8) "describe" [54]=> string(13) "deterministic" [55]=> string(8) "distinct" [56]=> string(11) "distinctrow" [57]=> string(3) "div" [58]=> string(6) "double" [59]=> string(4) "drop" [60]=> string(4) "dual" [61]=> string(4) "each" [62]=> string(4) "else" [63]=> string(6) "elseif" [64]=> string(5) "empty" [65]=> string(8) "enclosed" [66]=> string(7) "escaped" [67]=> string(6) "except" [68]=> string(6) "exists" [69]=> string(4) "exit" [70]=> string(7) "explain" [71]=> string(5) "false" [72]=> string(5) "fetch" [73]=> string(11) "first_value" [74]=> string(5) "float" [75]=> string(6) "float4" [76]=> string(6) "float8" [77]=> string(3) "for" [78]=> string(5) "force" [79]=> string(7) "foreign" [80]=> string(4) "from" [81]=> string(8) "fulltext" [82]=> string(8) "function" [83]=> string(9) "generated" [84]=> string(3) "get" [85]=> string(5) "grant" [86]=> string(5) "group" [87]=> string(8) "grouping" [88]=> string(6) "groups" [89]=> string(6) "having" [90]=> string(13) "high_priority" [91]=> string(16) "hour_microsecond" [92]=> string(11) "hour_minute" [93]=> string(11) "hour_second" [94]=> string(2) "if" [95]=> string(6) "ignore" [96]=> string(2) "in" [97]=> string(5) "index" [98]=> string(6) "infile" [99]=> string(5) "inner" [100]=> string(5) "inout" [101]=> string(11) "insensitive" [102]=> string(6) "insert" [103]=> string(3) "int" [104]=> string(4) "int1" [105]=> string(4) "int2" [106]=> string(4) "int3" [107]=> string(4) "int4" [108]=> string(4) "int8" [109]=> string(7) "integer" [110]=> string(8) "interval" [111]=> string(4) "into" [112]=> string(14) "io_after_gtids" [113]=> string(15) "io_before_gtids" [114]=> string(2) "is" [115]=> string(7) "iterate" [116]=> string(4) "join" [117]=> string(10) "json_table" [118]=> string(3) "key" [119]=> string(4) "keys" [120]=> string(4) "kill" [121]=> string(3) "lag" [122]=> string(10) "last_value" [123]=> string(4) "lead" [124]=> string(7) "leading" [125]=> string(5) "leave" [126]=> string(4) "left" [127]=> string(4) "like" [128]=> string(5) "limit" [129]=> string(6) "linear" [130]=> string(5) "lines" [131]=> string(4) "load" [132]=> string(9) "localtime" [133]=> string(14) "localtimestamp" [134]=> string(4) "lock" [135]=> string(4) "long" [136]=> string(8) "longblob" [137]=> string(8) "longtext" [138]=> string(4) "loop" [139]=> string(12) "low_priority" [140]=> string(11) "master_bind" [141]=> string(29) "master_ssl_verify_server_cert" [142]=> string(5) "match" [143]=> string(8) "maxvalue" [144]=> string(10) "mediumblob" [145]=> string(9) "mediumint" [146]=> string(10) "mediumtext" [147]=> string(9) "middleint" [148]=> string(18) "minute_microsecond" [149]=> string(13) "minute_second" [150]=> string(3) "mod" [151]=> string(8) "modifies" [152]=> string(7) "natural" [153]=> string(3) "not" [154]=> string(18) "no_write_to_binlog" [155]=> string(9) "nth_value" [156]=> string(5) "ntile" [157]=> string(4) "null" [158]=> string(7) "numeric" [159]=> string(2) "of" [160]=> string(2) "on" [161]=> string(8) "optimize" [162]=> string(15) "optimizer_costs" [163]=> string(6) "option" [164]=> string(10) "optionally" [165]=> string(2) "or" [166]=> string(5) "order" [167]=> string(3) "out" [168]=> string(5) "outer" [169]=> string(7) "outfile" [170]=> string(4) "over" [171]=> string(9) "partition" [172]=> string(12) "percent_rank" [173]=> string(7) "persist" [174]=> string(12) "persist_only" [175]=> string(9) "precision" [176]=> string(7) "primary" [177]=> string(9) "procedure" [178]=> string(5) "purge" [179]=> string(5) "range" [180]=> string(4) "rank" [181]=> string(4) "read" [182]=> string(5) "reads" [183]=> string(10) "read_write" [184]=> string(4) "real" [185]=> string(9) "recursive" [186]=> string(10) "references" [187]=> string(6) "regexp" [188]=> string(7) "release" [189]=> string(6) "rename" [190]=> string(6) "repeat" [191]=> string(7) "replace" [192]=> string(7) "require" [193]=> string(8) "resignal" [194]=> string(8) "restrict" [195]=> string(6) "return" [196]=> string(6) "revoke" [197]=> string(5) "right" [198]=> string(5) "rlike" [199]=> string(3) "row" [200]=> string(4) "rows" [201]=> string(10) "row_number" [202]=> string(6) "schema" [203]=> string(7) "schemas" [204]=> string(18) "second_microsecond" [205]=> string(6) "select" [206]=> string(9) "sensitive" [207]=> string(9) "separator" [208]=> string(3) "set" [209]=> string(4) "show" [210]=> string(6) "signal" [211]=> string(8) "smallint" [212]=> string(7) "spatial" [213]=> string(8) "specific" [214]=> string(3) "sql" [215]=> string(12) "sqlexception" [216]=> string(8) "sqlstate" [217]=> string(10) "sqlwarning" [218]=> string(14) "sql_big_result" [219]=> string(19) "sql_calc_found_rows" [220]=> string(16) "sql_small_result" [221]=> string(3) "ssl" [222]=> string(8) "starting" [223]=> string(6) "stored" [224]=> string(13) "straight_join" [225]=> string(6) "system" [226]=> string(5) "table" [227]=> string(10) "terminated" [228]=> string(4) "then" [229]=> string(8) "tinyblob" [230]=> string(7) "tinyint" [231]=> string(8) "tinytext" [232]=> string(2) "to" [233]=> string(8) "trailing" [234]=> string(7) "trigger" [235]=> string(4) "true" [236]=> string(4) "undo" [237]=> string(5) "union" [238]=> string(6) "unique" [239]=> string(6) "unlock" [240]=> string(8) "unsigned" [241]=> string(6) "update" [242]=> string(5) "usage" [243]=> string(3) "use" [244]=> string(5) "using" [245]=> string(8) "utc_date" [246]=> string(8) "utc_time" [247]=> string(13) "utc_timestamp" [248]=> string(6) "values" [249]=> string(9) "varbinary" [250]=> string(7) "varchar" [251]=> string(12) "varcharacter" [252]=> string(7) "varying" [253]=> string(7) "virtual" [254]=> string(4) "when" [255]=> string(5) "where" [256]=> string(5) "while" [257]=> string(6) "window" [258]=> string(4) "with" [259]=> string(5) "write" [260]=> string(3) "xor" [261]=> string(10) "year_month" [262]=> string(8) "zerofill" } ["target":protected]=> string(7) "default" ["key":protected]=> string(7) "default" ["logger":protected]=> NULL ["transactionLayers":protected]=> array(0) { } ["driverClasses":protected]=> array(2) { ["Select"]=> string(40) "Drupal\Core\Database\Driver\mysql\Select" ["Condition"]=> string(36) "Drupal\Core\Database\Query\Condition" } ["statementClass":protected]=> string(30) "Drupal\Core\Database\Statement" ["transactionSupport":protected]=> bool(true) ["transactionalDDLSupport":protected]=> bool(false) ["temporaryNameIndex":protected]=> int(0) ["connection":protected]=> object(PDO)#18 (0) { } ["connectionOptions":protected]=> array(10) { ["database"]=> string(7) "drupal8" ["username"]=> string(10) "casamarica" ["password"]=> string(18) "fb98iX*NHhQF{b-?6[" ["prefix"]=> array(1) { ["default"]=> string(0) "" } ["host"]=> string(9) "localhost" ["port"]=> string(4) "3306" ["namespace"]=> string(33) "Drupal\Core\Database\Driver\mysql" ["driver"]=> string(5) "mysql" ["pdo"]=> array(5) { [3]=> int(2) [1000]=> bool(true) [1005]=> bool(true) [20]=> bool(true) [1013]=> bool(false) } ["init_commands"]=> array(1) { ["sql_mode"]=> string(154) "SET sql_mode = 'ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER'" } } ["schema":protected]=> NULL ["prefixes":protected]=> array(1) { ["default"]=> string(0) "" } ["prefixSearch":protected]=> array(2) { [0]=> string(1) "{" [1]=> string(1) "}" } ["prefixReplace":protected]=> array(2) { [0]=> string(0) "" [1]=> string(0) "" } ["unprefixedTablesMap":protected]=> array(0) { } ["escapedNames":protected]=> array(15) { ["cache_container"]=> string(15) "cache_container" ["cache_config"]=> string(12) "cache_config" ["collection"]=> string(10) "collection" ["name"]=> string(4) "name" ["config"]=> string(6) "config" ["cache_discovery"]=> string(15) "cache_discovery" ["cache_data"]=> string(10) "cache_data" ["cache_bootstrap"]=> string(15) "cache_bootstrap" ["key_value"]=> string(9) "key_value" ["node.type"]=> string(9) "node.type" ["node.status"]=> string(11) "node.status" ["nid"]=> string(3) "nid" ["node_field_data"]=> string(15) "node_field_data" ["created"]=> string(7) "created" ["cache_entity"]=> string(12) "cache_entity" } ["escapedAliases":protected]=> array(4) { ["config"]=> string(6) "config" ["name"]=> string(4) "name" ["node"]=> string(4) "node" ["nid"]=> string(3) "nid" } ["rootTransactionEndCallbacks":protected]=> array(0) { } ["_serviceId"]=> string(8) "database" } ["allowRowCount"]=> bool(false) ["queryString"]=> string(1044) "SELECT recurrencia.entity_id,recurrencia.field_fecha_recurrente_value, recurrencia.field_fecha_recurrente_end_value FROM (((node__field_fecha_recurrente nodo inner join date_recur__node__field_fecha_recurrente recurrencia on nodo.entity_id=recurrencia.entity_id) inner join node_field_data d on d.nid=nodo.entity_id) inner join node__field_archivado_articulo a on a.entity_id=d.nid) inner join node__field_agenda_peso peso on peso.entity_id=d.nid where recurrencia.field_fecha_recurrente_value like :fecha and (recurrencia.field_fecha_recurrente_value >='2021-10-20' OR recurrencia.field_fecha_recurrente_end_value >='2021-10-20')and recurrencia.field_fecha_recurrente_value<=nodo.field_fecha_recurrente_end_value and d.status=1 and a.field_archivado_articulo_value<=recurrencia.field_fecha_recurrente_value and a.field_archivado_articulo_end_value>=recurrencia.field_fecha_recurrente_value order by DATE(recurrencia .field_fecha_recurrente_value) asc, DATE(recurrencia.field_fecha_recurrente_end_value) asc ,peso.field_agenda_peso_value asc" } Agenda | Casamérica