شما به دلایل زیر نمی توانید این سایت را ملاحظه نمایید:
لطفا یکی از صفحات زیر را امتحان کنید:
اگر واقعا در این مورد مصمم هستید لطفا با سرپرست سایت تماس بگیرید و خطای زیر را گزارش دهید
Unknown column 'final_price' in 'order clause' SQL=SELECT count(a.id) as a, count(b.id) as b, count(c.id) as c, count(d.id) as d, count(e.id) as e, count(f.id) as f, count(g.id) as g, count(h.id) as h, count(i.id) as i, count(j.id) as j, count(k.id) as k, count(l.id) as l, count(m.id) as m, count(n.id) as n, count(o.id) as o, count(p.id) as p, count(q.id) as q, count(r.id) as r, count(s.id) as s, count(t.id) as t, count(u.id) as u, count(v.id) as v, count(w.id) as w, count(x.id) as x, count(y.id) as y, count(z.id) as z FROM #__djc2_items as items left join #__djc2_items as a on a.id = items.id and lower(a.name) like 'a%' left join #__djc2_items as b on b.id = items.id and lower(b.name) like 'b%' left join #__djc2_items as c on c.id = items.id and lower(c.name) like 'c%' left join #__djc2_items as d on d.id = items.id and lower(d.name) like 'd%' left join #__djc2_items as e on e.id = items.id and lower(e.name) like 'e%' left join #__djc2_items as f on f.id = items.id and lower(f.name) like 'f%' left join #__djc2_items as g on g.id = items.id and lower(g.name) like 'g%' left join #__djc2_items as h on h.id = items.id and lower(h.name) like 'h%' left join #__djc2_items as i on i.id = items.id and lower(i.name) like 'i%' left join #__djc2_items as j on j.id = items.id and lower(j.name) like 'j%' left join #__djc2_items as k on k.id = items.id and lower(k.name) like 'k%' left join #__djc2_items as l on l.id = items.id and lower(l.name) like 'l%' left join #__djc2_items as m on m.id = items.id and lower(m.name) like 'm%' left join #__djc2_items as n on n.id = items.id and lower(n.name) like 'n%' left join #__djc2_items as o on o.id = items.id and lower(o.name) like 'o%' left join #__djc2_items as p on p.id = items.id and lower(p.name) like 'p%' left join #__djc2_items as q on q.id = items.id and lower(q.name) like 'q%' left join #__djc2_items as r on r.id = items.id and lower(r.name) like 'r%' left join #__djc2_items as s on s.id = items.id and lower(s.name) like 's%' left join #__djc2_items as t on t.id = items.id and lower(t.name) like 't%' left join #__djc2_items as u on u.id = items.id and lower(u.name) like 'u%' left join #__djc2_items as v on v.id = items.id and lower(v.name) like 'v%' left join #__djc2_items as w on w.id = items.id and lower(w.name) like 'w%' left join #__djc2_items as x on x.id = items.id and lower(x.name) like 'x%' left join #__djc2_items as y on y.id = items.id and lower(y.name) like 'y%' left join #__djc2_items as z on z.id = items.id and lower(z.name) like 'z%' where items.id in ( SELECT i.id FROM #__djc2_items as i INNER JOIN (SELECT ic.item_id FROM #__djc2_items_categories AS ic INNER JOIN #__djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND ic.category_id =1) as category_filter ON i.id = category_filter.item_id LEFT JOIN #__djc2_categories AS c ON c.id = i.cat_id LEFT JOIN #__djc2_producers AS p ON p.id = i.producer_id LEFT JOIN #__users AS ua ON ua.id = i.created_by WHERE i.producer_id = 1 AND i.published = 1 ORDER BY final_price desc , i.ordering, c.ordering )