SELECT tsk.*
            FROM ps_tecdoc_stock tsk
            INNER JOIN ps_tecdoc_supplier tsp ON tsk.id_tecdoc_supplier = tsp.id_tecdoc_supplier
            WHERE tsk.stock > 0
            AND tsk.stock >= tsk.minimum_order_quantity
            AND tsk.price > 0
            AND tsk.active = 1
            AND tsp.active = 1
            AND (tsk.brand, tsk.reference) IN (('jpn','30h1056-jpn')) GROUP BY tsk.id_tecdoc_supplier, tsk.brand, tsk.reference ORDER BY tsk.price;