500

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND a.product_downloadable = 1 AND a.state=1 AND a.fe' at line 26 SQL=SELECT a.id, a.title, a.title_alias,a.alias, a.introtext, a.fulltext, a.parentid, a.product_physical, a.product_downloadable, a.product_allfiles, a.product_sku, a.hits, a.price, a.featured, a.product_discount, a.product_package_ordering, a.file_downloads, a.product_package, a.file_length,a.file_time, a.file_name,a.file_preview,a.file_preview_2, a.file_preview_3,a.file_type, a.detail_image, p.id as parentid, p.title as product_title, p.alias as parent_alias, p.catid as artistid, p.product_made_date as product_made_date, p.created as created, p.publish_up as publish_up, p.modified as modified, c.title as category_name, c.alias as category_alias, s.sales, ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count, CASE WHEN p.created_by_alias > ' ' THEN p.created_by_alias ELSE ua.name END AS author FROM #__mymuse_product as a LEFT JOIN #__mymuse_product as p ON a.parentid = p.id LEFT JOIN #__categories as c ON a.catid = c.id LEFT JOIN #__mymuse_product_rating AS v ON a.id = v.product_id LEFT JOIN (SELECT sum(quantity) as sales, x.product_name, x.product_id FROM (SELECT sum(i.product_quantity) as quantity, i.product_id, p.parentid, i.product_name, product_id as all_id FROM #__mymuse_order_item as i LEFT JOIN #__mymuse_product as p ON i.product_id=p.id GROUP BY i.product_id ) as x GROUP BY x.all_id) as s ON s.product_id = a.id LEFT JOIN #__users AS ua ON ua.id = p.created_by LEFT JOIN #__users AS uam ON uam.id = p.modified_by WHERE a.parentid IN () AND a.product_downloadable = 1 AND a.state=1 AND a.featured=1 ORDER BY a.title ASC LIMIT 0, 10 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND a.product_downloadable = 1 AND a.state=1 AND a.fe' at line 26 SQL=SELECT a.id, a.title, a.title_alias,a.alias, a.introtext, a.fulltext, a.parentid, a.product_physical, a.product_downloadable, a.product_allfiles, a.product_sku, a.hits, a.price, a.featured, a.product_discount, a.product_package_ordering, a.file_downloads, a.product_package, a.file_length,a.file_time, a.file_name,a.file_preview,a.file_preview_2, a.file_preview_3,a.file_type, a.detail_image, p.id as parentid, p.title as product_title, p.alias as parent_alias, p.catid as artistid, p.product_made_date as product_made_date, p.created as created, p.publish_up as publish_up, p.modified as modified, c.title as category_name, c.alias as category_alias, s.sales, ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count, CASE WHEN p.created_by_alias > ' ' THEN p.created_by_alias ELSE ua.name END AS author FROM #__mymuse_product as a LEFT JOIN #__mymuse_product as p ON a.parentid = p.id LEFT JOIN #__categories as c ON a.catid = c.id LEFT JOIN #__mymuse_product_rating AS v ON a.id = v.product_id LEFT JOIN (SELECT sum(quantity) as sales, x.product_name, x.product_id FROM (SELECT sum(i.product_quantity) as quantity, i.product_id, p.parentid, i.product_name, product_id as all_id FROM #__mymuse_order_item as i LEFT JOIN #__mymuse_product as p ON i.product_id=p.id GROUP BY i.product_id ) as x GROUP BY x.all_id) as s ON s.product_id = a.id LEFT JOIN #__users AS ua ON ua.id = p.created_by LEFT JOIN #__users AS uam ON uam.id = p.modified_by WHERE a.parentid IN () AND a.product_downloadable = 1 AND a.state=1 AND a.featured=1 ORDER BY a.title ASC You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND a.product_downloadable = 1 AND a.state=1 AND a.fe' at line 26 SQL=SELECT a.id, a.title, a.title_alias,a.alias, a.introtext, a.fulltext, a.parentid, a.product_physical, a.product_downloadable, a.product_allfiles, a.product_sku, a.hits, a.price, a.featured, a.product_discount, a.product_package_ordering, a.file_downloads, a.product_package, a.file_length,a.file_time, a.file_name,a.file_preview,a.file_preview_2, a.file_preview_3,a.file_type, a.detail_image, p.id as parentid, p.title as product_title, p.alias as parent_alias, p.catid as artistid, p.product_made_date as product_made_date, p.created as created, p.publish_up as publish_up, p.modified as modified, c.title as category_name, c.alias as category_alias, s.sales, ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count, CASE WHEN p.created_by_alias > ' ' THEN p.created_by_alias ELSE ua.name END AS author FROM #__mymuse_product as a LEFT JOIN #__mymuse_product as p ON a.parentid = p.id LEFT JOIN #__categories as c ON a.catid = c.id LEFT JOIN #__mymuse_product_rating AS v ON a.id = v.product_id LEFT JOIN (SELECT sum(quantity) as sales, x.product_name, x.product_id FROM (SELECT sum(i.product_quantity) as quantity, i.product_id, p.parentid, i.product_name, product_id as all_id FROM #__mymuse_order_item as i LEFT JOIN #__mymuse_product as p ON i.product_id=p.id GROUP BY i.product_id ) as x GROUP BY x.all_id) as s ON s.product_id = a.id LEFT JOIN #__users AS ua ON ua.id = p.created_by LEFT JOIN #__users AS uam ON uam.id = p.modified_by WHERE a.parentid IN () AND a.product_downloadable = 1 AND a.state=1 AND a.featured=1 ORDER BY a.title ASC

Go Back Home