购物车为空

artist sidebox and music filter links


Modifcation of Record Company sidebox to create an Artist Sidebox.

Also includes optional extras to turn Genre, Artist and Record Company names into dynamic music typefilter links on the music product info pages.

I created this for my own record shop site.


插件版本: 2

该商品加入分类的日期为 2015年 01月 03日

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'zencart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from z138a_orders_products opa, z138a_orders_products opb, z138a_orders o, z138a_products p where opa.products_id = '13592' and opa.orders_id = opb.orders_id and opb.products_id != '13592' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]