Warning: A non-numeric value encountered in /var/www/duniabooking.com/html/app/controllers/CategoryController.php on line 28
Syntax error, unexpected token -, near to '12, 12', when parsing: SELECT a.id_product, LPAD(a.id_provider,12,0) as id_provider, a.id_module, a.duration, a.allotment, a.id_booking_window, a.product_status, a.product_view, a.product_sort, a.down_payment, a.hotdeals, b.id_product_detail, b.lang, b.product_name, b.product_desc, b.product_url, b.product_pagetitle, b.product_metakey, b.product_metadesc, d.module_name, e.basic_price, e.publish_price, e.price_currency, c.product_pix, (SELECT SUM(f.rating)/COUNT(f.id) FROM A_product_review f WHERE f.id_product = a.id_product) as review FROM A_products a LEFT JOIN A_products_detail b ON (a.id_product = b.id_product AND b.lang = 'en') LEFT JOIN G_modules d ON a.id_module = d.id_module LEFT JOIN A_product_prices e ON (e.id_product = a.id_product AND e.price_group = 'Default Price') LEFT JOIN A_products_pictures c ON c.id_product = a.id_product WHERE a.product_status = 1 AND a.id_module = 1 GROUP BY a.id_product ORDER BY RAND() LIMIT -12, 12 (1083)
#0 [internal function]: Phalcon\Mvc\Model\Query->parse()
#1 [internal function]: Phalcon\Mvc\Model\Query->execute()
#2 /var/www/duniabooking.com/html/app/controllers/CategoryController.php(66): Phalcon\Mvc\Model\Manager->executeQuery('SELECT\r\n    a.i...')
#3 /var/www/duniabooking.com/html/app/controllers/CategoryController.php(16): CategoryController->productlistmodule('1')
#4 [internal function]: CategoryController->listAction('1', 'accommodations', 'NAN')
#5 [internal function]: Phalcon\Dispatcher->callActionMethod(Object(CategoryController), 'listAction', Array)
#6 [internal function]: Phalcon\Dispatcher->dispatch()
#7 /var/www/duniabooking.com/html/public/index.php(42): Phalcon\Mvc\Application->handle()
#8 {main}