A generic term referring to the process of retrieving information from a database.

learn more… | top users | synonyms

0
votes
0answers
39 views

Custom Tax Query with special characters

I have this query that pulls posts form multiple custom taxonomies. IT works 98% of the time, the only time I have problems is when the term name has an apostraphe or special character, is there ...
0
votes
1answer
34 views

Sort by meta key within same day

I try to build something that can sort posts by day - and whithin the same day sort them with any meta value (integer) - like popularity or vote or what have you. So that, in the end, i get today's ...
0
votes
0answers
25 views

Query Search Not Working for Users

When I search for a User by their first name, all of their posts show up in the dashboard. When I search for that same User and add their last name, it does not show up at all. Not sure why this is ...
0
votes
1answer
530 views

WooCommerce - Query for ordered products

I'm trying to obtain all orders for particular day/time and then order products using SQL (MySQL) as seen in the query below: select p.ID as order_id, p.post_date, i.order_item_name, ...
-2
votes
1answer
26 views

Where can I find the SQL to get the most used information by wordpress database?

I tried to google "wordpress sql to get post url" and I was pretty astonished I couldn't find any resource sharing the SQL code to join the wp_post table with the table containing the permalink. How ...
0
votes
1answer
19 views

List of authors posts minus very latest

I'm creating an authors.php page to display all the posts for the author clicked. But the list(s) needs to show the very first / latest post so I can style it diferently than the rest of the posts? ...
0
votes
1answer
105 views

wpdb get_results() returns only 2 rows

I am trying to create custom admin widget to present how many users has registered within last days. I have created function as below: function mdbootstrap_add_dashboard_recent_users(){ global $wpdb;...
0
votes
1answer
175 views

cron job to auto delete posts of a specific post type older than x days

I want to delete all posts of a specific post type (in this case "vfb_entry") that are older than 60 days. The cron job should run once a day. I have the following code but it's not working if I ...
-2
votes
1answer
22 views

Show post like this image in my newssite [closed]

I want to know how to query like this photo in my newssite for a category. See this image and help by give the query code. Do I use Offset or if else. How to query for this .
0
votes
1answer
59 views

Custom Query - Based on user input

I'm working on displaying suggestions to an input, assisting the user. I'm using the included jQuery suggest. That's loading - and through ajax I'm using a custom SQL query and can see it's ...
0
votes
0answers
21 views

Query Database for URL

I have a multisite setup and was wondering how I can query a database to find and retrieve a URL if it exists, otherwise, don't output anything... For example, using the two following domains which ...
0
votes
1answer
52 views

wp_posts query slowing down my website

My website's been incredibly slow and I installed the query monitor plugin to learn more about the issues that caused this. When loading my index page, the following query takes 0,2412 (seconds?!) to ...
1
vote
0answers
43 views

Query to get number of posts last week

I want to receive each monday the number of posts that were posted on my site during the week. The first part of the code retrieves the number of posts, and the second part sends me an email with the ...
0
votes
0answers
7 views

Add current user filter on WordPress's default celendar

I want the WordPress default calendar to only show the posts from the current logged-in user. Not the entire posts of the site. I had to hack the general-template.php to do that but really need to ...
0
votes
1answer
48 views

Display year value before a set of posts

This is what I am trying to accomplish: I have a page template which displays "case studies" where "case studies" is a custom post type. the page template called: page-case-studies.php I actually ...
0
votes
1answer
31 views

Querying users by meta value and getting a strange answer

Here is my case: I am trying to get all users with some value related to a specific meta key. In other words, I don't want to select users that have nothing on that meta key (mps_finalDate). So here ...
0
votes
0answers
54 views

Restrict access to custom post type and filter from every query

I created a custom post type topic which is just for internal use. I managed to assign the correct capabilities so that users of certain roles can edit/publish/delete posts. Now I want to redirect ...
0
votes
4answers
159 views

Insert widgets into loop/custom query at every nth position

The basic challenge: I have a 'normal' custom query, e.g. of news posts from a certain category and want to add in several elements (CTAs, generally speaking) at every nth position, while the loop of ...
0
votes
0answers
43 views

Show posts in numeric price order using meta query combining 2 meta keys

I've built a custom estate agency website for a client but I'm stuck on this one last thing before it's good to launch. I'm using custom meta fields to allow for additional meta data such as Price, ...
0
votes
0answers
42 views

wp query custom orderby not custom field

I am working on a products archive page where I show 20 products on each page with pagination. Each product's price is calculated by a formule which gets his parameters by data saved in the database. ...
2
votes
1answer
35 views

Modifying loop on a custom page, strange behaviour

I want to setup a custom page on my site that pulls in posts from only one category. I've taken my main blog page template, duplicated the file and assigned it as a template to my new page. I've then ...
0
votes
0answers
87 views

Function inside shortcode doesn't display WP_Query properly - custom post type

I have a problem with some shortcode and a function to display list of shops based on another shortcode. I wrote some code: Shortcode function shops_list($atts){ extract(shortcode_atts(array( ...
0
votes
0answers
33 views

How set offset on query with specific post_type from functions.php

I have a page template called 'page-blog.php'. On that page I have 2 queries that both obtain the posts of a different post type like so: $posts = get_posts('post_type=posts&posts_per_page=3');//...
0
votes
1answer
40 views

Get previous posts list

I'll give up. Have searched and searched and tried and tried... Can't find any solution to list previous posts. On a single post: I want to show a list of the 10 previous posts, the 10 before the ...
0
votes
0answers
18 views

Displaying Taxonomy titles with their post

Suppose i have a taxonomy note_navigation like this Class 11 --Science --> THis is children of Class 11 ----Physics --> Children of Science and grandchildren of Class 11 ------ QUantum Physics ...
1
vote
2answers
145 views

Query string parameters from custom fields, inconsistent results

I've got a custom post type called course. Within a course post, I have a number of custom fields, specifically (all AFC select dropdowns): course_or_project, time_to_complete_project, ...
0
votes
1answer
38 views

Creating a custom search for a specific post type

Ok, so we know Wordpress comes with a built in search form. However, I've created a custom archive page that lists posts from a specific post type. I would like to integrate a search box that only ...
0
votes
1answer
38 views

Custom pagination (Title, date and teaser)

I'm working on implementing a custom pagination for a website. Unlike default Wordpress pagination with "Older" and "Newer" links, this one requires to show the title, the date and the teaser of the ...
0
votes
1answer
22 views

Mark a page of a queried menu as active

Im trying to mark as active a page of a queried menu --> (I found the answer) function render_main_menu(){ $args = array( 'post_type' => 'a_cpt', 'tax_query' => array( array(...
1
vote
1answer
14 views

My SQL function to change user_name

My wordPress database was hacked and all users_names were changed to the same thing. I'd like to write a mySql query to replace all usernames that = "x" to the user_nicename. I'm unsure how to do this ...
0
votes
1answer
111 views

Query Custom Post Types with checkboxes

I have Custom Post Type (Courses) with a field "course-location" that is a checkbox. I would like to filter the listing page with the checked items. The below code is working when I select ONE ...
1
vote
1answer
61 views

How select a specific query when setting offset?

In wordpress I added a function which sets the offset like so: add_action('pre_get_posts', 'myprefix_query_offset', 1 ); function myprefix_query_offset(&$query) { if ( ! $query->is_home() ...
-2
votes
1answer
63 views

Custom Query for wp_posts using wp_postmeta

In postmeta lets say meta_key = 'count' and meta_value = '5' meta_key = 'count' and meta_value = '6' meta_key = 'count' and meta_value = '7' now i want to get all post WHERE meta_key = 'count' ...
0
votes
0answers
68 views

Display result from custom post meta query

This is driving me crazy! I'm trying to simply echo the contents of a meta field (twitter) from the wp_postmeta table of a custom post type with the following query outside of the loop : global wpdb;...
1
vote
2answers
61 views

WP_Query Authors OR Categories

I'm trying to create a feed where posts are pulled based off a set of authors, OR a set of categories, but I haven't had much luck. I've tried using meta_query and tax_query, but neither worked. ...
0
votes
0answers
72 views

Standard WP_Query Returns No Results

Edit: found the problem. The fields I'm trying to filter on are custom fields. They were created with the "Load value based on the post's terms and update the post's terms on save" setting UNchecked. ...
0
votes
0answers
18 views

Custom Query Problem

I want to get posts specified with just parent category, not with childs of it. But when I'm using category property, posts_per_page not working. If I remove category proerty, posts_per_page working. ...
0
votes
0answers
24 views

Filtering by custom fields select?

I have a custom template listing all the posts under a category x. This is how my current loop looks like: <?php query_posts('cat=522'); while (have_posts()) : the_post();?> All the ...
0
votes
1answer
75 views

Using URL variables on a custom WP_Query

Background I have a page with a custom template 'listen', with a custom wp_query running on it... $custom_query_args = array( 'post_type' => 'post', 'tax_query' => array( array(...
1
vote
1answer
36 views

Style Post Differently In Query

Hi I'm using the query below to display 7 post from a certain tag, but I'm having a problem. I want to style the first post one way and the next 6 post differently. What I have noticed is that it ...
0
votes
1answer
21 views

Show certain number of post from tags

Hi i am using the query below to display post from a certain tag term, but what I want it to show multiple post. So far the query is displaying only 1 <?php $args = array('tag_slug__and' => ...
0
votes
0answers
73 views

Too many categories drastically slow down my website

I'm building a WordPress website that needs something like 7.000 categories. I added them, but now I have very long loading times. Pages need something like 30-40 seconds to load completely, and I'm ...
0
votes
1answer
60 views

How to fetch meta_value and meta_key in matrix after ajax request by post_id

Well, I have 2 custom post types: A = Properties B = Property Owners Inside CPT Properties, I was created a Meta Box to: Search a registred Owner (CPT) by VAT number (CPF in Brazil) Relate Owner ...
0
votes
0answers
38 views

How to use query on pre_get_comments?

I'm trying to make a search field for comments but when I try to modify the query in pre_get_comments nothing changes to the output. This same way IS working with pre_get_posts but for some reason I ...
0
votes
1answer
102 views

Help ordering custom query by Title, Ascending

I have an old project (custom post type query) that needs an alteration and my memory/skill level is lacking for what to do. With the code below, I'm needing to return the first query in alphabetical ...
0
votes
2answers
39 views

Write WP Query that selects posts that are part of the same two categories

How would I go about writing an intersect query (using WP Query) that returns a set of posts that are in both category A and category B?
0
votes
1answer
40 views

Show last 12 uploaded images on home page, but only from posts

I want to show the last 12 images that were published with articles on my front page. This is the code to get the latest 12 uploaded images, but i want to show only the ones attached to a post (single)...
0
votes
1answer
127 views

How to get posts from many categories using WP_Query

I'm trying to get posts from multiple specific categories. This is my code: $myquery= new WP_Query( array( 'posts_per_page'=>7, 'cat' => array(5,3,7), ) ); It isn't working - what am I ...
0
votes
1answer
63 views

How to add parameters for custom post type

I need to add a parameter to this custom query below. post_type=customer-stories&tag=microsoft,google I now need to add a parameter that will allow me to customize how many of each type of ...
0
votes
0answers
58 views

Ordering Posts by parent category, name ascending

I am currently creating a theme, and I have 2 parent categories: Budget and Brand. On home.php, I want to order all the posts ascending by their sub category name without showing the category title. ...