Наумов Алексей

две цены

у каждого товара множество цветов, у каждого цвета свои цены (две);

[[!getPage?
    &element=`pdoUsers`
    &groups=`Fisher`
    &limit=`15`
    &tpl=`users.List.Row`
    &sortby=`thislogin`
    &sortdir=`DESC`
    &where=`{"Comments.deleted = 0", "Comments.published = 1", "Publications.deleted = 0", "Publications.published = 1"}`
    &fastMode=`1`
    &select=`{"Comments":"COUNT(Comments.id) as comments_count", "Publications":"COUNT(Publications.id) as publications_count"}`
    &innerJoin = `{"Comments": {"class":"TicketComment","on":"Comments.createdby=modUser.id"}, "Publications": {"class":"modResource","on":"Publications.createdby=modUser.id"}}`
  ]]