I'm trying to do a lookup from collection1 to collection2 using attachments.collection2_keys (an array), and at the same time filter collection1 where collection2.type is typeA, for any key in attachments.collection2_keys. I believe this query should work, but it returns no…
hello i'm new in stack overflow, codeigniter 4 and dont have enough experience on mysql. I have a problem when i inserted data for the first time the data show on the table like it should be, but when i…
After the last update of Mailster (email marketing plugin for wordpress), they have changed the way they store the information about opens, clicks, unsubscribes... Until now, everything was stored in two databases: bao_posts: Like any other wordpress post, the information…
I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the course_registration table (based on mbr_id) 3- Join the…
"mytest_people" and "mytest_hobbies": PK FK <--- PK +----+------+------+------+ +----+-----------------+ | Id | Name | Age | H_ID | | Id | Hobby | +----+------+------+------+ +----+-----------------+ | 0 | Pete | 100 | 0 | | 0 | Reading News |…
I'm stuck in this query for while and any type of help would be appreciated. This is for a wordpress website which uses woocommerce. Trying to get purchase details of customers and I need to get a result set which…
I am trying to fetch posts with meta values where posts have some meta value. for pagination i need count of all rows matched with query so i can divide that into pages and serve to frontend. But I think…
This query lists out the distinct order numbers in Woocommerce that have order either of two products, where the orders are in a status called 'wc-on-hold'. The query does work, but if I comment back in the AND COUNT(t1.ID)=2 it…
SELECT zmogaus_id, hobio_id, hobio_pav2 FROM zmogaus_hobiai LEFT JOIN hobiai ON zmogaus_hobiai.hobio_pav2=hobiai.hobio_pav WHERE zmogaus_id=3 Using this I want to get zomgaus_id =3 . hobio_id =1 . hobio_pav2 =name1 (from hobio_pav) zomgaus_id =3 . hobio_id =2 . hobio_pav2 =name2 (from hobio_pav) But…
I am trying to write an sql statement in phpmyadmin. I have three tables - one tables has all of the data from my posts with a unique ID of wp_posts.ID. The other table is a tags table that has…