POSTA KOD NUMARASI:
TEMSIL EDILEN MARKALAR:
ŞIRKET HAKKINDA AÇIKLAMALAR:
International Auction Group (IAG) is a Spanish company with global reach specializing in the sale of industrial equipment across all sectors.
We offer a comprehensive service to companies and industries which want to BUY used equipment, as well as to insolvency administrators, lawyers, economists and financial institutions which, due to a closure, relocation or change of its production lines wish to SELL their assets.
We offer sales support, asset valuation and inventory and logistics services for dismantling and removing goods.
Thanks to our partnerships with major international investment groups, our operations include buying and selling whole production plants, production lines and machinery of any size and sector. Our strategic alliances allows us to ensure great agility and efficiency in the valuation and sale of assets. We also specialize in the management and sale of real estate and stock.
Our company is a pioneer in Spain for conducting Online Auctions where to sell company assets, Real Estate or carrying Private treaty auctions. Our own technological platform guarantees clients and insolvency administrators a transparent, efficient and reliable purchase process.
SELECT * FROM `view_prodotto` LEFT JOIN ( SELECT * FROM `catalogo_prodotto_immagini` GROUP BY IDProdotto ) AS b ON ( view_prodotto.IDProdotto = b.IDProdotto ) WHERE view_prodotto.IDUtente = AND b.IDImmagine IS NOT NULL AND b.Annullato = 0 AND b.uri <> '' AND Stato = 1 AND view_prodotto.created <= UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -7 DAY)) ORDER BY view_prodotto.IDProdotto DESC