Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
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....
Ilja's user avatar
  • 1,268
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 ...
Hamza Mustafa's user avatar