I’ve a quite lengthy and complex SQL question.
I need to use instructions like SET @varible, GROUP_CONCAT, PREPARE, EXECUTE, DEALLOCATE PREPARE, case when, and many others.
I would like this knowledge from the DB to assemble the web page.
It really works effectively by way of the myphpadmin, however I get no outcomes utilizing:
$wpdb->get_results ( $question );
Which I suppose is not the proper operate to execute this one. How do I method it appropriately?
How do you execute queries which have greater than only a easy choose?
Sorry for the lengthy textual content, right here is the complete question: question
Deferentially from this reply: hyperlink
I do not assume I can separate my question into subqueries.