WP_Query Object
(
[query] => Array
(
[eventDisplay] => custom
[post_type] => tribe_events
[posts_per_page] => -1
[meta_key] => _EventStartDate
[orderby] => _EventStartDate
[order] => ASC
[hide_upcoming] => 1
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => _EventStartDate
[compare] => >=
[value] => 2021-11-30 00:00:00
)
[1] => Array
(
[key] => _EventEndDate
[compare] => <=
[value] => 2021-11-30 23:59:59
)
[2] => Array
(
[key] => exclude_event
[value] => 0
)
)
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => tribe_events_cat
[field] => id
[terms] => Array
(
[0] => 847
[1] => 833
)
[operator] => NOT IN
)
)
)
[query_vars] => Array
(
[eventDisplay] => custom
[post_type] => tribe_events
[posts_per_page] => -1
[meta_key] => _EventStartDate
[orderby] => _EventStartDate
[order] => ASC
[hide_upcoming] => 1
[meta_query] => Array
(
[0] => Array
(
[key] => _EventStartDate
[type] => DATETIME
)
[relation] => AND
[1] => Array
(
[key] => _EventStartDate
[compare] => >=
[value] => 2021-11-30 00:00:00
)
[2] => Array
(
[key] => _EventEndDate
[compare] => <=
[value] => 2021-11-30 23:59:59
)
[3] => Array
(
[key] => exclude_event
[value] => 0
)
)
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => tribe_events_cat
[field] => id
[terms] => Array
(
[0] => 847
[1] => 833
)
[operator] => NOT IN
)
)
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
[0] => 58927
[1] => 60699
[2] => 61661
[3] => 62826
[4] => 64043
[5] => 66088
[6] => 67200
[7] => 69189
[8] => 70252
[9] => 71299
[10] => 71615
[11] => 71670
[12] => 71788
[13] => 72056
[14] => 72646
[15] => 76680
[16] => 76776
[17] => 76968
[18] => 77657
[19] => 77812
[20] => 78025
[21] => 78380
[22] => 78478
[23] => 78613
[24] => 78739
[25] => 79038
[26] => 79196
[27] => 79948
[28] => 80178
[29] => 80434
[30] => 80579
[31] => 80810
[32] => 81117
[33] => 81864
[34] => 82025
[35] => 82484
[36] => 82704
[37] => 82836
[38] => 82930
[39] => 83034
[40] => 83194
[41] => 83354
[42] => 83821
[43] => 84103
[44] => 84255
[45] => 84395
[46] => 84546
[47] => 84737
[48] => 84905
[49] => 85294
[50] => 85568
[51] => 85842
[52] => 86223
[53] => 86466
[54] => 86610
[55] => 86835
[56] => 87064
[57] => 87208
[58] => 87259
[59] => 87358
[60] => 87463
[61] => 87601
[62] => 87712
[63] => 87794
[64] => 87883
[65] => 87985
[66] => 88154
[67] => 88284
[68] => 88364
[69] => 88478
[70] => 88568
[71] => 88667
[72] => 88829
[73] => 88944
[74] => 89101
[75] => 89173
[76] => 89275
[77] => 89397
[78] => 89563
[79] => 90645
[80] => 90711
[81] => 90919
[82] => 91106
[83] => 91223
[84] => 91316
[85] => 91435
[86] => 91577
[87] => 92092
[88] => 92182
[89] => 92239
[90] => 92691
[91] => 93172
[92] => 94181
[93] => 59817
[94] => 94500
[95] => 95436
[96] => 95547
[97] => 95655
[98] => 96159
[99] => 96399
[100] => 65162
[101] => 96641
[102] => 96765
[103] => 96890
[104] => 68243
[105] => 97041
[106] => 97132
[107] => 97219
[108] => 97332
[109] => 97428
[110] => 97501
[111] => 97527
[112] => 97664
[113] => 98040
[114] => 73942
[115] => 98223
[116] => 75049
[117] => 98349
[118] => 76081
[119] => 98461
[120] => 98521
[121] => 98689
[122] => 98874
[123] => 77140
[124] => 98882
[125] => 98885
[126] => 98886
[127] => 98888
[128] => 98889
[129] => 98890
[130] => 98980
[131] => 99181
[132] => 99238
[133] => 99352
[134] => 78231
[135] => 99446
[136] => 99502
[137] => 99593
[138] => 99762
[139] => 99895
[140] => 78902
[141] => 100069
[142] => 100209
[143] => 100285
[144] => 100427
[145] => 100533
[146] => 100614
[147] => 100746
[148] => 100795
[149] => 100935
[150] => 81380
[151] => 123740
[152] => 229802
[153] => 231171
[154] => 232296
[155] => 307291
[156] => 308812
[157] => 309696
[158] => 311854
[159] => 313502
[160] => 315820
[161] => 316965
[162] => 83643
[163] => 317716
[164] => 318297
[165] => 318882
[166] => 319248
[167] => 320135
[168] => 320366
[169] => 320568
[170] => 320775
[171] => 320841
[172] => 321047
[173] => 321240
[174] => 321284
[175] => 321399
[176] => 321419
[177] => 321448
[178] => 321697
[179] => 321958
[180] => 322112
[181] => 322264
[182] => 322430
[183] => 322521
[184] => 322651
[185] => 322721
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[tribe_include_date_meta] => 1
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] => 1
[comments_per_page] => 50
[no_found_rows] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => tribe_events_cat
[terms] => Array
(
[0] => 847
[1] => 833
)
[field] => id
[operator] => NOT IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
)
[queried_terms] => Array
(
)
[primary_table] => mlc_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => _EventStartDate
)
[1] => Array
(
[0] => Array
(
[key] => _EventStartDate
[type] => DATETIME
)
[1] => Array
(
[key] => _EventStartDate
[compare] => >=
[value] => 2021-11-30 00:00:00
)
[2] => Array
(
[key] => _EventEndDate
[compare] => <=
[value] => 2021-11-30 23:59:59
)
[3] => Array
(
[key] => exclude_event
[value] => 0
)
[relation] => AND
)
[relation] => AND
)
[relation] => AND
[meta_table] => mlc_postmeta
[meta_id_column] => post_id
[primary_table] => mlc_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => mlc_postmeta
[1] => mt1
[2] => mt2
[3] => mt3
[4] => mt4
)
[clauses:protected] => Array
(
[mlc_postmeta] => Array
(
[key] => _EventStartDate
[compare] => =
[compare_key] => =
[alias] => mlc_postmeta
[cast] => CHAR
)
[mt1] => Array
(
[key] => _EventStartDate
[type] => DATETIME
[compare] => =
[compare_key] => =
[alias] => mt1
[cast] => DATETIME
)
[mt2] => Array
(
[key] => _EventStartDate
[compare] => >=
[value] => 2021-11-30 00:00:00
[compare_key] => =
[alias] => mt2
[cast] => CHAR
)
[mt3] => Array
(
[key] => _EventEndDate
[compare] => <=
[value] => 2021-11-30 23:59:59
[compare_key] => =
[alias] => mt3
[cast] => CHAR
)
[mt4] => Array
(
[key] => exclude_event
[value] => 0
[compare] => =
[compare_key] => =
[alias] => mt4
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT DISTINCT mlc_posts.*, MIN(mlc_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM mlc_posts INNER JOIN mlc_postmeta ON ( mlc_posts.ID = mlc_postmeta.post_id ) INNER JOIN mlc_postmeta AS mt1 ON ( mlc_posts.ID = mt1.post_id ) INNER JOIN mlc_postmeta AS mt2 ON ( mlc_posts.ID = mt2.post_id ) INNER JOIN mlc_postmeta AS mt3 ON ( mlc_posts.ID = mt3.post_id ) INNER JOIN mlc_postmeta AS mt4 ON ( mlc_posts.ID = mt4.post_id ) LEFT JOIN mlc_postmeta as tribe_event_end_date ON ( mlc_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) LEFT JOIN mlc_postmeta c ON mlc_posts.ID = c.post_id and c.meta_key like '_wplp_%' and (( mlc_posts.post_type in ('post','page') and (c.meta_key in ( '_wplp_post_front') )) OR ( mlc_posts.post_type='page' and (c.meta_key in ( '_wplp_post_front','_wplp_hide_frontpage','_wplp_hide_always','_wplp_nohide_search') ))) WHERE 1=1 AND mlc_posts.ID NOT IN (58927,60699,61661,62826,64043,66088,67200,69189,70252,71299,71615,71670,71788,72056,72646,76680,76776,76968,77657,77812,78025,78380,78478,78613,78739,79038,79196,79948,80178,80434,80579,80810,81117,81864,82025,82484,82704,82836,82930,83034,83194,83354,83821,84103,84255,84395,84546,84737,84905,85294,85568,85842,86223,86466,86610,86835,87064,87208,87259,87358,87463,87601,87712,87794,87883,87985,88154,88284,88364,88478,88568,88667,88829,88944,89101,89173,89275,89397,89563,90645,90711,90919,91106,91223,91316,91435,91577,92092,92182,92239,92691,93172,94181,59817,94500,95436,95547,95655,96159,96399,65162,96641,96765,96890,68243,97041,97132,97219,97332,97428,97501,97527,97664,98040,73942,98223,75049,98349,76081,98461,98521,98689,98874,77140,98882,98885,98886,98888,98889,98890,98980,99181,99238,99352,78231,99446,99502,99593,99762,99895,78902,100069,100209,100285,100427,100533,100614,100746,100795,100935,81380,123740,229802,231171,232296,307291,308812,309696,311854,313502,315820,316965,83643,317716,318297,318882,319248,320135,320366,320568,320775,320841,321047,321240,321284,321399,321419,321448,321697,321958,322112,322264,322430,322521,322651,322721) AND (
mlc_posts.ID NOT IN (
SELECT object_id
FROM mlc_term_relationships
WHERE term_taxonomy_id IN (895,909)
)
) AND (
mlc_postmeta.meta_key = '_EventStartDate'
AND
(
mt1.meta_key = '_EventStartDate'
AND
( mt2.meta_key = '_EventStartDate' AND mt2.meta_value >= '2021-11-30 00:00:00' )
AND
( mt3.meta_key = '_EventEndDate' AND mt3.meta_value <= '2021-11-30 23:59:59' )
AND
( mt4.meta_key = 'exclude_event' AND mt4.meta_value = '0' )
)
) AND mlc_posts.post_type = 'tribe_events' AND (mlc_posts.post_status = 'publish' OR mlc_posts.post_status = 'acf-disabled' OR mlc_posts.post_status = 'tribe-ea-success' OR mlc_posts.post_status = 'tribe-ea-failed' OR mlc_posts.post_status = 'tribe-ea-schedule' OR mlc_posts.post_status = 'tribe-ea-pending' OR mlc_posts.post_status = 'tribe-ea-draft' OR mlc_posts.post_status = 'dp-rewrite-republish') AND mlc_posts.ID NOT IN ( SELECT ID FROM mlc_posts WHERE post_type IN ('post','page','attachment','tcb_symbol','product','testimonials','mlc-in-the-news','mlc-tv','webinars','my-journal','landing_page','tva_lesson','tva_chapter','tva_module','tcb_lightbox','tribe_venue','tribe_organizer','tribe_events','tribe-ea-record','memorial_wall','wc_product_retailer') AND ID IN ( SELECT post_id FROM mlc_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM mlc_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) AND mlc_posts.ID IN ( SELECT ID FROM mlc_posts WHERE ID NOT IN ( SELECT post_id FROM mlc_postmeta WHERE mlc_postmeta.meta_key = 'groups-groups_read_post' ) UNION ALL SELECT post_id AS ID FROM mlc_postmeta WHERE mlc_postmeta.meta_key = 'groups-groups_read_post' AND mlc_postmeta.meta_value IN ('') ) AND c.post_id IS NULL GROUP BY mlc_posts.ID ORDER BY EventStartDate ASC, mlc_postmeta.meta_value ASC
[posts] => Array
(
)
[post_count] => 0
[current_post] => -1
[in_the_loop] =>
[comment_count] => 0
[current_comment] => -1
[found_posts] => 0
[max_num_pages] => 0
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => 5c6e8532e0ffd8ab14bc638a2baab1b4
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
[tribe_is_event] => 1
[tribe_is_multi_posttype] =>
[tribe_is_event_category] =>
[tribe_is_event_venue] =>
[tribe_is_event_organizer] =>
[tribe_is_event_query] => 1
[tribe_is_past] =>
[tribe_is_week] =>
[tribe_is_photo] =>
[tribe_is_map] =>
[tribe_is_event_pro_query] => 1
)
