All Questions
2 questions
9
votes
2
answers
11k
views
magento2 search_tmp join leads to empty results in category listing
I just imported products into fresh magento2 instance and encountered issue that category product listing block are empty, although the products successfully appear in database . I have debugged list....
3
votes
2
answers
2k
views
how to get status of last order id in magento2 sql query?
i want to get last order id along with order status in magneto2, i use this query to extract it but the status is not extracting correct:
SELECT max(entity_id) , STATUS FROM sales_order
max ...