Advertisement
Guest User

eventmysqlqyery

a guest
Dec 19th, 2014
281
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.02 KB | None | 0 0
  1.    [201] => Array
  2.           (
  3.               [0] =>
  4.       SELECT    p.ID as id,
  5.           p.post_title as title,
  6.           p.post_content as description,
  7.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_id_calendar' LIMIT 1) as id_calendar,
  8.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_date' LIMIT 1) as date,
  9.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_all_day' LIMIT 1) as all_day,
  10.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_daily_working_days' LIMIT 1) as pec_daily_working_days,
  11.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_daily_every' LIMIT 1) as pec_daily_every,
  12.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_weekly_every' LIMIT 1) as pec_weekly_every,
  13.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_weekly_day' LIMIT 1) as pec_weekly_day,
  14.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_recurring_frecuency' LIMIT 1) as recurring_frecuency,
  15.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_end_date' LIMIT 1) as end_date,
  16.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_link' LIMIT 1) as link,
  17.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_share' LIMIT 1) as share,
  18.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_map' LIMIT 1) as map,
  19.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_end_time_hh' LIMIT 1) as end_time_hh,
  20.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_end_time_mm' LIMIT 1) as end_time_mm,
  21.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_hide_time' LIMIT 1) as hide_time,
  22.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_location' LIMIT 1) as location,
  23.           (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_phone' LIMIT 1) as phone
  24.       FROM wp_posts p
  25.       WHERE
  26.      
  27.         (((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_date' LIMIT 1) BETWEEN '2014-12-01 00:00:00' AND '2014-12-31 23:59:59') OR
  28.         ((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_end_date' LIMIT 1) BETWEEN '2014-12-01 00:00:00' AND '2014-12-31 23:59:59')
  29.         OR ((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_recurring_frecuency' LIMIT 1) > 0))
  30.       AND ((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_id_calendar' LIMIT 1) = 1 OR (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_id_calendar' LIMIT 1) LIKE '%,1' OR (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_id_calendar' LIMIT 1) LIKE '%,1,%' OR (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_id_calendar' LIMIT 1) LIKE '1,%') AND p.post_status = 'publish'
  31.       ORDER BY (SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'pec_date' LIMIT 1) ASC
  32.               [1] => 0.023564100265503
  33.               [2] => require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/artculture/page.php'), get_sidebar, locate_template, load_template, require_once('/themes/artculture/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, DpProEventCalendar_AccordionWidget->widget, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, dpProEventCalendar_simple_shortcode, dpProEventCalendar_wpress_display->dpProEventCalendar_wpress_display, dpProEventCalendar_wpress_display->return_dpProEventCalendar, DpProEventCalendar->output, DpProEventCalendar->eventsMonthList, DpProEventCalendar->upcomingCalendarLayout
  34.           )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement