SELECT `product_id` AS product_id, `name_ru-RU` AS product_name, `alias_ru-RU` AS alias FROM `al9rm_jshopping_products` ORDER BY RAND( ) LIMIT 3

You need to display the latest products in random, such as

 SELECT MAX `product_id` ORDER BY RAND( ) LIMIT 3
  • one
    Well? What is the problem then? - EatMyDust
  • The top query is the output in the randomness of the goods. Bottom - the output of the last 3 products by id (if not mistaken). How to combine them? - tomas_morgam

0