• Resolved mehuljogi

    (@mehuljogi)


    Hi,

    Can you let me know how i can fire the sql query for the recurring event. i am not much aware about recurring date with the sql.

    my query is like this

    Select
    wp_vdqp_term_taxonomy.term_id,
    wp_vdqp_posts.ID,
    wp_vdqp_posts.post_title,
    wp_vdqp_posts.post_content,
    wp_vdqp_terms.name,
    wp_vdqp_ai1ec_event_instances.start,
    wp_vdqp_ai1ec_event_instances.end
    From
    wp_vdqp_posts Inner Join
    wp_vdqp_term_relationships
    On wp_vdqp_posts.ID = wp_vdqp_term_relationships.object_id Inner Join
    wp_vdqp_term_taxonomy On wp_vdqp_term_relationships.term_taxonomy_id =
    wp_vdqp_term_taxonomy.term_taxonomy_id Inner Join
    wp_vdqp_terms On wp_vdqp_term_taxonomy.term_id = wp_vdqp_terms.term_id
    Inner Join
    wp_vdqp_ai1ec_events On wp_vdqp_posts.ID = wp_vdqp_ai1ec_events.post_id
    Inner Join
    wp_vdqp_ai1ec_event_instances
    On wp_vdqp_posts.ID = wp_vdqp_ai1ec_event_instances.id
    Where
    wp_vdqp_term_taxonomy.term_id = 135
    Order By
    wp_vdqp_ai1ec_events.start

    and i want the repeated events in this query can you help me please.

    Thanks in advance

    https://www.ads-software.com/plugins/all-in-one-event-calendar/

  • The topic ‘event recurring sql query’ is closed to new replies.