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…
I have created MySQL data model to store content along with its custom attributes/field. Below is a simplified version of it. One for storing content: CREATE TABLE `cms_content` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `content_type_id`…
I am using mysql and here is the schema that I have. First table: Keywords +------------+-------------+ | keyword_id | keyword_tag | +------------+-------------+ | 2 | marketing | | 58 | sales | | 59 | scraping | | 1 |…