i am trying to do a table with wordpress post ,ive went threw your manual few times and still keep runing into the same problem , first is grouping to show only one post and not show the same post with multiple category , when i try to group category i get an error , and if i group anything else it works but then the category filter dont work correctly , its shows all categories in one line as one ,

second problem each post have external url iam trying to make the title clickable to original link permlink here is my sql code 

SELECT posts_post.post_date AS post_post_date,        posts_post.post_title AS post_post_title,        CONCAT('<a href="',posts_post.guid,'">',posts_post.post_title,'</a>') AS post_title_with_link_to_post,        posts_post_author.display_name AS post_post_author,        GROUP_CONCAT(distinct post_taxonomy_category_tbl.name) AS post_taxonomy_category,        GROUP_CONCAT(distinct post_meta_original_link_tbl.meta_value) AS post_meta_original_link FROM wpag_posts AS posts_post   INNER JOIN wpag_users AS posts_post_author      ON posts_post_author.ID = posts_post.post_author   INNER JOIN (SELECT name, object_id as id FROM wpag_terms AS post_taxonomy_category_tbl_terms INNER JOIN wpag_term_taxonomy AS post_taxonomy_category_tbl_termtaxonomy ON post_taxonomy_category_tbl_termtaxonomy.term_id = post_taxonomy_category_tbl_terms.term_id  AND post_taxonomy_category_tbl_termtaxonomy.taxonomy = 'category' INNER JOIN wpag_term_relationships AS rel_post_taxonomy_category_tbl  ON post_taxonomy_category_tbl_termtaxonomy.term_taxonomy_id = rel_post_taxonomy_category_tbl.term_taxonomy_id) AS post_taxonomy_category_tbl      ON post_taxonomy_category_tbl.ID = posts_post.id    INNER JOIN (SELECT post_meta_original_link_tbl_posts.ID as id, meta_value, meta_key  FROM wpag_postmeta AS post_meta_original_link_tbl_postmeta  INNER JOIN wpag_posts AS post_meta_original_link_tbl_posts   ON post_meta_original_link_tbl_postmeta.post_id = post_meta_original_link_tbl_posts.ID   AND post_meta_original_link_tbl_posts.post_type = 'post') AS post_meta_original_link_tbl      ON post_meta_original_link_tbl.meta_key = 'original_link' AND post_meta_original_link_tbl.id = posts_post.ID  WHERE 1=1     AND posts_post.post_status = 'publish'    AND posts_post.post_type = 'post' GROUP BY post_post_date

what changes i need to do  to make title clickable to the permalink and fix grouping issue also please let me know is it possible to show a table based on todays date only " allpost will be posted based on that day only "

thanks in advance 

thanks for the information ive figured out how to pull the post from wordpress correctly , my skills on sql are not so good i am aameture wheredo i put this code at for to show only for today post

select * from dt_table where  `date` = CURDATE()"

how much would you charge to make a simple wordpress post table where its shows only current day post and also able to link to the title of the post with its original meta link , this is what i am trying to do . the table is gona have 

post id , post date, post title, post author , post category .

basically i am trying to build WordPress table from the post where it pulls only post from today's date and with the original meta link
need 6 columns for :

post id , post date , post author, post category, post title, post original meta link
post title should be linked to the original meta link, I tried using
POST_TITLE_WITH_LINK_TO_POST but it is sending users to the internal link  each post have an external link


here is the login info for the demo site

username : Aleksandar
password: Aleksandar@24111984

https://avidanbanks.com/demosite/wp-admin

you the man can i appreciate it alot can you tell me what was the sql query for to show todays date for the feature 

basically it will be yesterday and one for daybefore yesterday 

thanks for the reply iv alread used that code and few others that i found on stakeover flow they all oull data from the the previous date and onwards i need only that previous date so had an idea to put a condition logic on the table to earse everything or clear cell if its 00:00 and onwards , here are the codes i found 

SELECT SUBDATE(CURDATE(), 1);

or

SELECT CURDATE() - INTERVAL 1 DAY;

or

SELECT SUBDATE(CURDATE(), INTERVAL 1 DAY);

or

SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY);

there are few other things custimization that are needed  such as refreshing the table autonaticly for sql that option is not there , i sign up to the website u sent me hopefully ill get a response from one of the developers , you guys are awsome anyways i do appreciate the help 

hey on my page it take forever to load then i get this message

 DataTables warning: table id=table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

how can i speed up the page load 

here is my page 

https://news-il.co.il/%d7%90%d7%a8%d7%9b%d7%99%d7%95%d7%9f/

hey i went over all setting currentlyi have every thing going threw cloudflare and when its enable it slows down the loading of website when i deactivate the plugin then website is fast , its a shared hosting account do ypu know how i can fix this what are the configuration for cloudflare i also do have a security plugin only threw cloudflare