Skip to content

WordPress database error Incorrect usage of UNION and LIMIT #25

@anormore

Description

@anormore

[28-Nov-2017 22:10:52 UTC] WordPress database error Incorrect usage of UNION and LIMIT for query SELECT SQL_CALC_FOUND_ROWS tables.* FROM ( SELECT wp_posts., '1' AS site_ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'slider' AND ((wp_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_2_posts., '2' AS site_ID FROM wp_2_posts WHERE 1=1 AND wp_2_posts.post_type = 'slider' AND ((wp_2_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_5_posts., '5' AS site_ID FROM wp_5_posts WHERE 1=1 AND wp_5_posts.post_type = 'slider' AND ((wp_5_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_7_posts., '7' AS site_ID FROM wp_7_posts WHERE 1=1 AND wp_7_posts.post_type = 'slider' AND ((wp_7_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_8_posts., '8' AS site_ID FROM wp_8_posts WHERE 1=1 AND wp_8_posts.post_type = 'slider' AND ((wp_8_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_9_posts., '9' AS site_ID FROM wp_9_posts WHERE 1=1 AND wp_9_posts.post_type = 'slider' AND ((wp_9_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_11_posts., '11' AS site_ID FROM wp_11_posts WHERE 1=1 AND wp_11_posts.post_type = 'slider' AND ((wp_11_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_14_posts., '14' AS site_ID FROM wp_14_posts WHERE 1=1 AND wp_14_posts.post_type = 'slider' AND ((wp_14_posts.post_status = 'publish')) LIMIT 0, 20 UNION SELECT wp_15_posts.*, '15' AS site_ID FROM wp_15_posts WHERE 1=1 AND wp_15_posts.post_type = 'slider' AND ((wp_15_posts.post_status = 'publish')) LIMIT 0, 20) tables ORDER BY tables.post_date DESC LIMIT 0, 10 made by do_action('wp_ajax_askyu_search'), WP_Hook->do_action, WP_Hook->apply_filters, askyu_search, WP_Query_Multisite->__construct, WP_Query->query, WP_Query->get_posts

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions