Syntax error, unexpected token ), near to ' GROUP BY p.id', when parsing: SELECT p.id, p.sku, p.name, p.slug, p.description, p.page_title, p.metadata, p.provider, pr.latitude, pr.longitude, pr.name AS provider_name, pr.slug AS provider_slug,
        (SELECT opt.rate_option_price FROM Rate_options opt LEFT JOIN Rates r ON opt.id_rate = r.id WHERE r.product = p.id LIMIT 1),  
        p.group_product, f.name AS picture, 
        (SELECT SUM(r.review_star) / COUNT(r.id) FROM Product_reviews r WHERE r.product_id = p.id) AS review,
        (SELECT COUNT(r.id) FROM Product_reviews r WHERE r.product_id = p.id) AS reviewCount, 
        p.module, p.metadata, p.itinerary, p.inclusion_exclusion, p.policy, gp.group_product_url  
        FROM Products p 
        LEFT JOIN Group_products gp ON gp.group_product = p.group_product 
        LEFT JOIN Upload_file_morph uf ON uf.related_id = p.id 
        LEFT JOIN Upload_file f ON f.id = uf.upload_file_id  
        LEFT JOIN Providers pr ON pr.id = p.provider
        WHERE uf.related_type = 'products' 
        AND (p.published_by != 0 OR p.published_by != '')
        AND p.id IN () GROUP BY p.id (1082)<br><pre>#0 [internal function]: Phalcon\Mvc\Model\Query->parse()
#1 [internal function]: Phalcon\Mvc\Model\Query->execute()
#2 /var/www/lifestyle.tropialis.com/app/controllers/ArticlesController.php(167): Phalcon\Mvc\Model\Manager->executeQuery('SELECT p.id, p....')
#3 /var/www/lifestyle.tropialis.com/app/controllers/ArticlesController.php(70): ArticlesController->getproduct('')
#4 [internal function]: ArticlesController->detailAction('1166', 'agam-rinjani-he...', '1166', 'agam-rinjani-he...')
#5 [internal function]: Phalcon\Dispatcher->callActionMethod(Object(ArticlesController), 'detailAction', Array)
#6 [internal function]: Phalcon\Dispatcher->dispatch()
#7 /var/www/lifestyle.tropialis.com/public/index.php(42): Phalcon\Mvc\Application->handle()
#8 {main}</pre>