I'd like to generate a table that consists of list of all available tables and number of rows for each of them. Table Name Number of rows SCHEMA.TABLE_NAME1 30 SCHEMA.TABLE_NAME2 40 I've used the query below: select schema_name(tab.schema_id) + '.'…
I have the following documents: _id: "Team 1" count: 1200 _id: "Team 2" count: 1170 _id: "Team 3" count: 1006 _id: "Team 4" count: 932 _id: "Team 5" count: 931 _id: "Team 6" count: 899 _id: "Team 7" count: 895…
i've a problem with Wordpress. This is the error message: PHP 7.2 Warning count(): Parameter must be an array or an object that implements Countable /web/htdocs/www.firenzeflowershow.com/home/wp-content/themes/wpex-elegant/functions/meta/init.php on line 750 > elseif ( is_array( $meta_box['pages'] ) && count( $meta_box['pages'] > ===…
I have a table with all the users activities and another table with all the users login events. Each of them has a datatime field (creation). I need to count for a specific user with one query how many activities…
I am surprised to see that there is no way to simply get the number of followers for one Twitter account. I found many answers (Follower count number in Twitter, How to obtain follower count in Twitter API 1.1?, How…
I am using the following code: /* Woocommerce - Add Product Count View in Each Category */ add_action( 'woocommerce_before_shop_loop', 'add_product_count_view', 20); function add_product_count_view() { $terms = get_the_terms( $post->ID, 'product_cat'); foreach( $terms as $term ) { if(is_tax('product_cat', $term->name)) { echo '<span…
I'm seeking for solution on how to get count for 3 faculty code then sum all the count in one variable. I didn't found the right query to combine the count and then sum it. This is the code that…
I use the official woocommerce booking plugin and I try do get the quantity of all persons that have booked a product. for a single order that's no problem with: if ( is_callable( 'WC_booking_Data_Store::get_booking_ids_from_order_id') ) { $booking_data = new WC_booking_Data_Store();…
I have a list of different channels that could potentially bring users to a website (organic, SEO, online marketing, etc.). I would like to find an efficient way to count daily active user that comes from the combination of these…
I'm trying to get the posts count inside my product category page loop (Woocommerce), but it just doesn't work. Does anyone knows why? Woocommerce uses the same file archive-product.php for displaying both Shop Page and Product Category Page. In my…