Query Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'p.create_datetime DESC
LIMIT 5' at line 5
Query: SELECT p.*,p.id
FROM shop_product p
WHERE p.status = 1
AND 0
ORDER BY p .,p.create_datetime DESC
LIMIT 5 code 1064

## wa-system/database/waModel.class.php(257)
#0 wa-system/database/waModel.class.php(357): waModel->run('SELECT p.*,p.id...')
#1 wa-apps/shop/lib/classes/shopProductsCollection.class.php(1634): waModel->query('SELECT p.*,p.id...')
#2 wa-apps/shop/lib/classes/shopViewHelper.class.php(186): shopProductsCollection->getProducts('*', 0, '5', true)
#3 wa-apps/shop/lib/classes/shopViewHelper.class.php(229): shopViewHelper->products('set/recommended', 0, '5', Array)
#4 wa-cache/apps/shop/templates/compiled/shop_ru_RU/ba/e8/a8/bae8a8c12fb67f0211ad8e360959d1a79253d26b.file.sidebar.html.php(63): shopViewHelper->productSet('recommended', 0, '5')
#5 wa-system/vendors/smarty3/sysplugins/smarty_internal_templatebase.php(184): content_5df34562daee72_97947628(Object(Smarty_Internal_Template))
#6 wa-system/vendors/smarty3/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch(NULL, NULL, NULL, NULL, false, false, true)
#7 wa-cache/apps/shop/templates/compiled/shop_ru_RU/a2/4a/da/a24ada7a6aa4a1f198dbf8d778656b8f1dc37204.file.main.html.php(228): Smarty_Internal_Template->getSubTemplate('/var/www/plitka...', NULL, 'shop_ru_RU', NULL, NULL, Array, 0)
#8 wa-system/vendors/smarty3/sysplugins/smarty_internal_templatebase.php(184): content_5df344e2e5e4d7_86348567(Object(Smarty_Internal_Template))
#9 wa-system/vendors/smarty3/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch(NULL, NULL, NULL, NULL, false, false, true)
#10 wa-cache/apps/shop/templates/compiled/shop_ru_RU/90/a2/5f/90a25fbb3f37d35ca18c3846ad70ff9f488483e5.file.index.html.php(228): Smarty_Internal_Template->getSubTemplate('/var/www/plitka...', NULL, 'shop_ru_RU', NULL, NULL, Array, 0)
#11 wa-system/vendors/smarty3/sysplugins/smarty_internal_templatebase.php(184): content_5df344e20284c4_82006704(Object(Smarty_Internal_Template))
#12 wa-system/vendors/smarty3/sysplugins/smarty_internal_templatebase.php(378): Smarty_Internal_TemplateBase->fetch('file:index.html', NULL, NULL, NULL, true)
#13 wa-system/view/waSmarty3View.class.php(129): Smarty_Internal_TemplateBase->display('file:index.html', NULL)
#14 wa-system/layout/waLayout.class.php(150): waSmarty3View->display('file:index.html')
#15 wa-system/controller/waViewController.class.php(104): waLayout->display()
#16 wa-system/controller/waViewController.class.php(47): waViewController->display()
#17 wa-system/controller/waFrontController.class.php(255): waViewController->run(NULL)
#18 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(waDefaultViewController), NULL)
#19 wa-system/controller/waFrontController.class.php(84): waFrontController->execute('dynamiccategori...', 'frontend', 'dyncat')
#20 wa-system/waSystem.class.php(884): waFrontController->dispatch()
#21 wa-system/waSystem.class.php(578): waSystem->dispatchFrontend('category/Harlem...')
#22 index.php(7): waSystem->dispatch()
#23 {main}

GET

array()

Params

array(
  'app' => 'shop',
  'theme' => 'supreme',
  'theme_mobile' => 'mobile',
  'checkout_version' => '1',
  'locale' => 'ru_RU',
  'ssl_all' => '1',
  'title' => '',
  'meta_keywords' => '',
  'meta_description' => '',
  'og_title' => '',
  'og_image' => '',
  'og_video' => '',
  'og_description' => '',
  'og_type' => '',
  'og_url' => '',
  'url_type' => '1',
  'type_id' => '0',
  'currency' => 'UAH',
  'public_stocks' => '0',
  'drop_out_of_stock' => '0',
  'payment_id' => '0',
  'shipping_id' => '0',
  'checkout_storefront_id' => 'eaab9da53be6a7dff2317df1aa4c747f',
  'dyncat' => 'Harlem_Porcelanosa',
  'action' => 'category',
  'module' => 'frontend',
  'plugin' => 'dynamiccategories',
  'parsed_url_params' => array(
    0 => array(
      0 => array(
        0 => '<dyncat>',
        1 => 9,
      ),
      1 => array(
        0 => 'dyncat',
        1 => 10,
      ),
      2 => array(
        0 => '',
        1 => 16,
      ),
    ),
  ),
  'category_url' => 'Harlem_Porcelanosa',
)