mysql - Combining two SQL queries to create an automatic procedure? -


I've visited this forum several times to find answers to my questions, but this is my first post. This is a specific question, so I was searching for what I was searching for.

My SQL is quite limited, I have just learned what I should do, as I have gone together, but it is well on my head!

I run a free pub advertising website - Our-Pub.co.uk. Pub can add your upcoming events to your individual pages along with a comprehensive pub guide. This is a completely free service, both pubs and pub hollers support

I use WordPress for my backend. Some added events are weekly / fortnightly events and I want to automatically publish them again. I was thinking that this can be done to investigate events by running a stored procedure and they are marked weekly / fortnightly by adding 604800 (or 604800x2) seconds.

At this time I have 2 SQL queries that I run, first to find all events marked as weekly or fortnight ... 

  SELECT ID, post_title , wpr.object_id, wp_redhouseterms.name wp_redhouseterms to Join iNNER wp_redhouseterm_taxonomy wp_redhouseterms .term_id = wp_redhouseterm_taxonomy.term_id dusting Join wp_redhouseterm_relationships wpr.term_taxonomy_id = wp_redhouseterm_taxonomy.term_taxonomy_id ID = wpr.object_id inner wp_redhouseposts where classification = 'category' and wp_redhouseterms.term_id = 18 or wp_redhouseterms.term_id = 25 and post_type = 'post' order by `wpr` ._object_id`dessc   
 This gives a list of those posts that are marked weekly / fortnightly with their post ID and whether they are weekly or fortnightly events. I can then use this list of post IDs in my next query to return the list of current ID time values ​​...  
  SELECT meta_id, post_id, meta_value FROM `wp_redhousepostmeta` WHERE Like 'event_date_time' and 'post_id' ('post') like '1726' or post_id '2296' or post_id like '1655' or post_id like '2373' or '2371' or post_id '1650' or post_id like 'meta_key' Like '1652' or '3036' like Post_ID or 'Post_ID' 1580 'or' 2375 'like Post_ID or' Post_ID '4128' or 'Like' Oost_ID '4132' .... etc ....   
 I am updating this list manually, weekly events or 604800 for fortnight events from 1206 600 By adding.  
 This was quite manageable at first but the list is increasing and now a real pain is going to be updated!  
 Any of you, the SQL Wizard, Advice how can I add these two scripts and to run at 3:00 p.m. To rigger, do I ask myself to update the events?  
 I have to go to myself, but there was no luck, honestly, I have lost!  
 Any help will be highly appreciated!  
 Thank you, Mark us - Pub.co.uk   
 
 
 Assume that  18  is weekly and  25  is fortnightly, the following should update the events appropriately:  
  UPDATE wp_redhousepostmeta rh INNER JOIN ( SELECT ID, wt.term_id wp_terms wt INNER JOIN wp_term_taxonomy wtt wt.term_id = wtt.term_id INR wp_term_relationships wpr.term_taxonomy_id wpr.term_taxonomy_id wpr.term_taxonomy_id enter ID on inner wp_posts = wpr.object_id where classification = 'category' and ( Wt.term_id = 18 or wt.term_id = 25) and post_type = 'post') rh.post_id = t.ID at t SET rh.meta_value = rh.meta_value + cases When t.term_id = 18 THEN 604800 WHEN T Term_id = 25 THEN 1209600 end where rh.meta_key = 'event_date_time';   
 Check it first by running the following and everything looks correct:  
  SELECT t.id, t.term_id, rh.meta_value, rh.meta_value + Case when TTR_ID = 18 THEN 604800 WHEN t.term_id = 25 THEN 1209600 END as new_meta_value wp_redhousepostmeta Join R Inner (SELECT ID, wt.term_id wp_terms wt INNER JOIN wp_term_taxonomy wtt.term_id = wtt.term_id INNER JOIN Wp_term_relationships wpr.term_taxonomy_id = wtt.term_taxonomy_id enter wp_posts on INNER id = wpr.object_id WHERE classification = 'category' and (wt.term_id = 18 or wt.term_id = 25) and rhi on post_type = 'post') Post_id = T.ID WHERE rh.meta_key = 'event_date_time'

Comments

Post a Comment

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

I was trying to use the program to use mifrewan on 4 node clusters. Distributing node 0 data in nodes 1, 2 and 3. In the program, from '90 'to variable values ​​of' dior 'to be calculated. Therefore the node is distributing data and collecting results in an omitted fashion (for different values ​​of var 'dir') when do {*******} Whereas (dir Loop is given, Mippun is hanging, and no output is found. But when I comment on two {*******} (dir The loop output is obtained for the initial value of variable dir dir = -90 ), and that output is correct. The problem occurs when the loop is given. Can anyone help me in solving this problem. #include "mpi.h" int main (int argc, char * argv []) Float dir = -90; Int rank, nanoprakash; MPI_Status status; MPI_Init (& amp; argc, & argv); MPI_Comm_rank (MPI_COMM_WORLD, & amp; Rank); MPI_Comm_size (MPI_COMM_WORLD, & amp; numprocs); If (rank == 0) {/ / data to begin / / (dest = 1; dest ...
Read more

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

I can not find anything in the source about using coupons after subscribing to a user's plan. Is it possible to use a coupon to credit a user's membership after initial subscription? If not, what is the best option? Specifically, I want to give a user 100% coupon for that month, when they take 5 [site specific actions]. This is possible, but may not be the best idea. Coupons are currently applied to the stripe, then apply again at the customer level and each client can have a single coupon. So if you are already offering discounts to the coupon, then the customer who is currently in the present will also give up. It also means that if you are using a recently-added multiple subscription capacity, then all of the user's subscription will be ready for the month. Coupons can be set to "Once", only once (as the only name) can be used by any customer, so if this credit can earn more than once, You will have to maintain a 100% discount coupon continuousl...
Read more

java - Unable to get JDBC connection in Spring application to MySQL -

मैंने स्प्रिंग में डीबी कॉन्फ़िगरेशन का पालन किया है: & lt; bean id = "dataSource" Class = "org.apache.commons.dbcp.BasicDataSource" नष्ट-विधि = "बंद" & gt; & Lt; प्रॉपर्टी नाम = "url" मान = "jdbc: dburl" / & gt; & Lt; संपत्ति नाम = "driverClassName" मान = "com.mysql.jdbc.Driver" / & gt; & Lt; संपत्ति नाम = "उपयोगकर्ता नाम" मान = "उपयोगकर्ता नाम" / & gt; & Lt; संपत्ति नाम = "पासवर्ड" मान = "पासवॉर्फ" / & gt; & Lt; प्रॉपर्टी नाम = "हटाए गए हटाए गए" मान = "सही" / & gt; & Lt; गुण नाम = "प्रारंभिक आकार" मान = "3" / & gt; & Lt; संपत्ति नाम = "अधिकतमअक्टिव" मान = "5" / & gt; & Lt; / सेम ​​& gt; डीबी से गुण मूल्यों को लोड करने के लिए अतिरिक्त कॉन्फ़िगरेशन। & lt; bean id = "config1" class = "org.apache.commons.configuration....
Read more