SQL Error: The used SELECT statements have a different number of columns
Called From: products->set_data() in [edit/modules/products/products.class.php:4346]
SQL: ( SELECT `RECORDID`, `TITLE`, '' AS `SUBTITLE`, `TITLE` AS `SEARCHTERMS`, `REFTITLE`, '' AS `SUMMARY`, `DESCRIPTION`, '' AS `BRAND`, '' AS `CATEGORIES`, 0 AS `PRICE`, 0 AS `AVAILABLE_SHARES`, 0 AS `SPECIALOFFER`, `IMAGE`, '' AS `VIDEOS`, '' AS `PEDIGREE`, 'category' AS `TYPE`, `SORTNUM` ,1=1 FROM `TABLE_PRODUCT_CATEGORIES` WHERE `SECTION` = 'edit60d3d3ce77de8' AND `PARENTID` = 'edit60efb50c1d3d1' AND `ALLYEAR` <> 0 ) UNION ALL ( SELECT `RECORDID`, `TITLE`, '' AS `SUBTITLE`, `TITLE` AS `SEARCHTERMS`, `REFTITLE`, '' AS `SUMMARY`, `DESCRIPTION`, '' AS `BRAND`, '' AS `CATEGORIES`, 0 AS `PRICE`, 0 AS `AVAILABLE_SHARES`, 0 AS `SPECIALOFFER`, `IMAGE`, '' AS `VIDEOS`, '' AS `PEDIGREE`, 'group' AS `TYPE`, `SORTNUM` ,1=1 FROM `TABLE_PRODUCT_GROUPS` WHERE `SECTION` = 'edit60d3d3ce77de8' AND `PARENTID` = 'edit60efb50c1d3d1' AND `ALLYEAR` <> 0 ) UNION ALL ( SELECT `RECORDID`, `TITLE`, `SUBTITLE`, `SEARCHTERMS`, `REFTITLE`, `SUMMARY`, `DESCRIPTION`, `BRAND`, `CATEGORIES`, `PRICE`, `AVAILABLE_SHARES`, `SPECIALOFFER`, `IMAGES` AS `IMAGE`, `VIDEOS` AS `VIDEOS`, `PEDIGREE`, 'product' AS `TYPE`, `SORTNUM` FROM ( SELECT *, CONCAT_WS( ' ', `TITLE`, `VARIANTTERMS1`, `VARIANTTERMS2`, `VARIANTTERMS3` ) AS `SEARCHTERMS`, ( SELECT `PRICE` FROM `TABLE_PRODUCT_VARIANTS` WHERE `PARENTID` = `TABLE_PRODUCTS`.`RECORDID` AND `USEVARIANT` <> 0 ORDER BY CASE WHEN `PRICE` > 0 THEN 1 ELSE 2 END ASC, `PRICE` ASC LIMIT 1 ) AS `PRICE`, ( SELECT `SPECIALOFFER` FROM `TABLE_PRODUCT_VARIANTS` WHERE `PARENTID` = `TABLE_PRODUCTS`.`RECORDID` AND `USEVARIANT` <> 0 ORDER BY CASE WHEN `SPECIALOFFER` > 0 THEN 1 ELSE 2 END ASC, `SPECIALOFFER` ASC LIMIT 1 ) AS `SPECIALOFFER` FROM `TABLE_PRODUCTS` INNER JOIN ( SELECT `PARENTID`, GROUP_CONCAT(`OPTION1VALUE` SEPARATOR ' ') AS `VARIANTTERMS1`, GROUP_CONCAT(`OPTION2VALUE` SEPARATOR ' ') AS `VARIANTTERMS2`, GROUP_CONCAT(`OPTION3VALUE` SEPARATOR ' ') AS `VARIANTTERMS3` FROM `TABLE_PRODUCT_VARIANTS` WHERE `USEVARIANT` <> 0 GROUP BY `PARENTID` ) AS `TABLE_PRODUCT_VARIANTS` ON `TABLE_PRODUCT_VARIANTS`.`PARENTID` = `TABLE_PRODUCTS`.`RECORDID`) AS `TABLE_PRODUCTS` WHERE `SECTION` = 'edit60d3d3ce77de8' AND `ALLYEAR` <> 0 AND `SPECIALOFFER` > 0 ) ORDER BY `TYPE` ASC, 1=1, IF(`SORTNUM` <> '',`SORTNUM`,999999), `TITLE` LIMIT 50 OFFSET 0