SELECT a.*, aus.*  FROM auc_auction a LEFT JOIN auc_auction_shop aus ON (a.id_auction = aus.id_auction AND aus.id_shop = 10) WHERE a.active = 1 AND a.ending_date > "2024-11-19 07:22:00" AND aus.id_shop = 10 ORDER BY a.ending_date ASC LIMIT 12 OFFSET 0