INSERT IGNORE INTO `new`.`article-tags`
SELECT * FROM `spisanie8`.`article-tags`;

INSERT IGNORE INTO `new`.`articles` (`ID`, `IntDate`, `PostDate`, `LastUpdate`, `GroupID`, `MetaTitle`, `MetaDescription`, `URLLabel`, `Section`, `Title`, `Annotation`, `Gallery`, `GalleryLabels`, `GalleryAlt`, `VideoURL`, `Content`, `Tags`, `Author`, `RelatedArticles`,           `AddOn`, `Subscribe`, `Featured`, `OnlineSub`, `Visible`, `Comments`, `Hits`)
SELECT * FROM `spisanie8`.`articles`;


INSERT IGNORE INTO `new`.`authors`
SELECT * FROM `spisanie8`.`authors`;

INSERT IGNORE INTO `new`.`banners`
SELECT * FROM `spisanie8`.`banners`;

INSERT IGNORE INTO `new`.`banner_stats`
SELECT * FROM `spisanie8`.`banner_stats`;

TRUNCATE TABLE `new`.`basket`;
-- ???
TRUNCATE TABLE `new`.`basket_code`;

INSERT IGNORE INTO `new`.`bulletin`
SELECT * FROM `spisanie8`.`bulletin`;

INSERT IGNORE INTO `new`.`bulletin_send`
SELECT * FROM `spisanie8`.`bulletin_send`;

INSERT IGNORE INTO `new`.`bulletin_send_emails`
SELECT * FROM `spisanie8`.`bulletin_send_emails`;

INSERT IGNORE INTO `new`.`bulletin_unsubscribed`
SELECT * FROM `spisanie8`.`bulletin_unsubscribed`;

INSERT IGNORE INTO `new`.`bulletin_users`
SELECT * FROM `spisanie8`.`bulletin_users`;

INSERT IGNORE INTO `new`.`countries`
SELECT * FROM `spisanie8`.`countries`;

INSERT IGNORE INTO `new`.`econt-offices`
SELECT * FROM `spisanie8`.`econt-offices`;

INSERT IGNORE INTO `new`.`gifts`
SELECT * FROM `spisanie8`.`gifts`;

INSERT IGNORE INTO `new`.`groups`
SELECT * FROM `spisanie8`.`groups`;

INSERT IGNORE INTO `new`.`guests`
SELECT * FROM `spisanie8`.`guests`;

INSERT IGNORE INTO `new`.`magazines`
SELECT * FROM `spisanie8`.`magazines`;

INSERT IGNORE INTO `new`.`magazine_articles`
SELECT * FROM `spisanie8`.`magazine_articles`;

INSERT IGNORE INTO `new`.`orders`
SELECT * FROM `spisanie8`.`orders`;

INSERT IGNORE INTO `new`.`orders_remind`
SELECT * FROM `spisanie8`.`orders_remind`;

INSERT IGNORE INTO `new`.`orders_remind_send`
SELECT * FROM `spisanie8`.`orders_remind_send`;

INSERT IGNORE INTO `new`.`order_products`
SELECT * FROM `spisanie8`.`order_products`;

INSERT IGNORE INTO `new`.`order_vouchers`
SELECT * FROM `spisanie8`.`order_vouchers`;

INSERT IGNORE INTO `new`.`pages` (`ID`, `PostDate`, `LastUpdate`, `MetaTitle`, `MetaDescription`, `Title`, `Annotation`, `URLLabel`, `MenuLabel`, `Image`, `Content`, `AddOn`, `Rules`, `Visible`)
SELECT `ID`, `PostDate`, `LastUpdate`, `MetaTitle`, `MetaDescription`, `Title`, `Annotation`, `URLLabel`, `MenuLabel`, `Image`, `Content`, `AddOn`, `Rules`, `Visible` FROM `spisanie8`.`pages`;

INSERT IGNORE INTO `new`.`patreon`
SELECT * FROM `spisanie8`.`patreon`;

INSERT IGNORE INTO `products` (`ID`, `PostDate`, `LastUpdate`, `GroupID`, `MetaTitle`, `MetaDescription`, `Title`, `Annotation`, `URLLabel`, `Image`, `Content`, `Weight`, `Price`, `PromoPrice`, `OnlinePrice`, `PromoOnlinePrice`, `Voucher`, `MagazinesType`, `MagazinesNum`, `PDF`, `Gallery`, `VideoURL`, `FullPagesNum`, `InStock`, `GiftType`, `GiftValue`, `EMailLabel`, `EMailContent`, `AddOn`, `Visible`)
SELECT `ID`, `PostDate`, `LastUpdate`, `GroupID`, `MetaTitle`, `MetaDescription`, `Title`, `Annotation`, `URLLabel`, `Image`, `Content`, `Weight`, `Price`, `PromoPrice`, `OnlinePrice`, `PromoOnlinePrice`, `Voucher`, `MagazinesType`, `MagazinesNum`, `PDF`, `Gallery`, `VideoURL`, `FullPagesNum`, `InStock`, `GiftType`, `GiftValue`, `EMailLabel`, `EMailContent`, `AddOn`, `Visible` FROM `spisanie8`.`products`;

INSERT IGNORE INTO `new`.`promocodes`
SELECT * FROM `spisanie8`.`promocodes`;

INSERT IGNORE INTO `new`.`promocode_orders`
SELECT * FROM `spisanie8`.`promocode_orders`;

INSERT IGNORE INTO `new`.`refunds`
SELECT * FROM `spisanie8`.`refunds`;

INSERT IGNORE INTO `new`.`slider`
SELECT * FROM `spisanie8`.`slider`;

INSERT IGNORE INTO `new`.`status`
SELECT * FROM `spisanie8`.`status`;

INSERT IGNORE INTO `new`.`subscriptions`
SELECT * FROM `spisanie8`.`subscriptions`;

INSERT IGNORE INTO `new`.`subscription_code`
SELECT * FROM `spisanie8`.`subscription_code`;

INSERT IGNORE INTO `new`.`tags`
SELECT * FROM `spisanie8`.`tags`;

INSERT IGNORE INTO `new`.`users`
SELECT * FROM `spisanie8`.`users`;

INSERT IGNORE INTO `new`.`vouchers`
SELECT * FROM `spisanie8`.`vouchers`;

INSERT IGNORE INTO `new`.`voucher_orders`
SELECT * FROM `spisanie8`.`voucher_orders`;

ALTER TABLE `articles` ADD `Blocks` VARCHAR(255) NULL DEFAULT NULL AFTER `RelatedArticles`;

ALTER TABLE `products` ADD `Blocks` VARCHAR(255) NULL DEFAULT NULL AFTER `EMailContent`;


UPDATE `articles` SET `Featured` = 1 ORDER BY `PostDate` DESC LIMIT 100