I need mySQL query for database is Magento 1.9,
I need select attribute from table:
Last 10 Invoice one random product, costumer name, Country, product name, Time (h), image path, product link.
I need only Query like this:
SELECT * FROM sales_flat_invoice_item, sales_flat_invoice_grid WHERE sales_flat_invoice_item.product_id=sales_flat_invoice_grid.order_id ORDER BY RAND();");
21 freelancers κάνουν προσφορές κατά μέσο όρο $35 για αυτή τη δουλειά
Hi, I would like to write mysql query to get random record from last 10 invoices. Get in touch to discuss more. Available to start now. Regards, Manish
Hello Friend, I am a Magento2 Certified Associate Developer and looking for long term clients. I can write the mysql query for you, let me know if I can help you in any way. Thanks.
Senor database administrator is here with expertise and grasp knowledge in multiple Databases. Looking forward to hear from you to resolve your query. Regards, B.