SELECT *
FROM mod_store_items
WHERE id_sys_website_variants = ? AND (id_mod_store_inventory IN (
SELECT id_mod_store_inventory
FROM mod_store_inventory_properties
WHERE id_mod_store_properties_values IN (3277)) OR variant IN (
SELECT id_mod_store_inventory
FROM mod_store_inventory_properties
WHERE id_mod_store_properties_values IN (3277))) AND for_sale = 1
ORDER BY `order`
LIMIT 0, 24
Array ( [0] => 78 )
Core\Db\QueryException: Unknown column 'order' in 'order clause' in C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Db\Db.php:424 Stack trace: #0 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Db\Db.php(358): Core\Db\Db->Query('\nSELECT *\nFROM ...', Array) #1 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Db\Db.php(535): Core\Db\Db->FetchAll('\nSELECT *\nFROM ...', Array, 2, true) #2 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Db\Query.php(200): Core\Db\Db::FetchAllStat('\nSELECT *\nFROM ...', Array, 2, true) #3 C:\inetpub\wwwroot\Webs\The Grace\Grace\Modules\Store\Server\Libs\Items.php(30): Core\Db\Query->FetchAll() #4 C:\inetpub\wwwroot\Webs\The Grace\Grace\Modules\Store\Server\Store.php(788): Modules\Store\Server\Libs\Items->LoadItems() #5 C:\inetpub\wwwroot\Webs\The Grace\Grace\Modules\Store\Server\Store.php(737): Modules\Store\Server\Store->ShowProducts(true) #6 C:\inetpub\wwwroot\Webs\The Grace\Grace\Modules\Store\Server\Store.php(115): Modules\Store\Server\Store->ShowMainProducts() #7 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Document\Modules\Modules.php(134): Modules\Store\Server\Store->Show() #8 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Document\Template.php(363): Core\Document\Modules\Modules::GetModule('Main') #9 C:\inetpub\wwwroot\Webs\The Grace\Grace\Core\Document\Template.php(157): Core\Document\Template::BaseReplace('\r\n