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 = 2 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('2')
#4 [internal function]: CategoryController->listAction('2', 'wellness', '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}