1054 - 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 )

شما به دلایل زیر نمی توانید این سایت را ملاحظه نمایید:

  1. مطلب از انتشار خارج شده باشد
  2. یک موتور جستجو که یک لیست تاریخ گذشته از این سایت دارد
  3. یک آدرس اشتباه تایپ شده است
  4. شما به این صفحه دسترسی ندارید
  5. منبع خواسته شده پیدا نشد.
  6. در هنگام پردازش درخواست شما خطایی رخ داده است

لطفا یکی از صفحات زیر را امتحان کنید:

اگر واقعا در این مورد مصمم هستید لطفا با سرپرست سایت تماس بگیرید و خطای زیر را گزارش دهید

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 )