Notice: Error: Unknown column 'p.date' in 'order clause'
Error No: 1054
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY p.date DESC, LCASE(pd.name) DESC LIMIT 0,2 in /var/www/name-story.com/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Warning: Invalid argument supplied for foreach() in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Notice: Error: Unknown column 'p.date' in 'order clause'
Error No: 1054
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY p.date DESC, LCASE(pd.name) DESC LIMIT 0,2 in /var/www/name-story.com/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Warning: Invalid argument supplied for foreach() in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246}}wENf,rb첻!93iIm[txsB $d$1d0@ $0eǒ KZ֋#űG!nݺ֯;ɃSZ+;vϙO=aq6r3+xNL+t,e NLc<D;OD?J56PW n ݄1g&<'(p{R?9Qe o6h\w5c7t뛓4ƴK㪴d/f '0<7 yQm6D/3fr $VE @Oa -W0h]RAǿFA'#ŵÞxZòEe` UPY.bFm1uGsdj[MQކE'Oϸѓڴ}{&](xvM 鞵"ğBħ\6zz,V >k taB _IJ8F% M6X<5b%@E;x(aitj[)nWfVvQv=87 / +OXza3Q# xLK=;Q*]3W.b +SN¦דNvާOO0X.{ Xč9W-hz~E+;7ʹ}DIwP3vH}3cu|yl 9;˨<𦉎E<[~uQrNؽW;9}~`Pzt456216O٬,/b.~-^E5P,[I t?Q\ni ͅRB %-Ljù}گ%er 8a==^r5&JǵHYEȏi3(< ESuNj4l-A'Ic1ox6v&5xK:.Ÿ%fX1Դ5Qz!{=kz &QVQv8;e5cPԬAڋ"`o~lb6T1Gl5YڴOiMbp  /o#Z%R mR{)&ʗéM4>EQ~sF%vF72ÉprEQKx3x6!#Pl0:nfb\7!qmqm@n_cF0k%iU2a<{891iB P5bmNOLR{FFFpņFڿEYR%=@C/G =FMQ/>IgUYt,n1}cg:&ͳe[F,P :d"M>󸙛cc$1INb#o7X0~Ƀ3h>`@+Ep7Xַ<7?ն2vnQo[7\+V0f8TΜXq3,}!A ձ%~K ŗb_w1t˨#gϔi b܋Ziͅnybb፤eˣIU1 a5t-X/dyT]Cw+N% #`eh1EXA[W/DOR"=KL7̥10ˍ"LaN1&Yo j0lL0a-UP2~hI)T xfI֠Fhoga?5lKԝK/ϐ."}2蛐 I6Y#Gvn࢑3EqIb=줣LHq-snr.{z잲 썗;ĽL=,)*=͛9(y'`6P)lRALv#I:+(Nfnnpe k@0bHF9ҥg]cţ8ե;}*DLK$Se@?gdĴțۈFLjdWI31-]TN~hBjڇ7C*kRWƱ2K\x3O|OWV~:5SV/5GD;;%hS}"&o SnH`BMdnE6)P[1R8avl!3F[";Ke K%ũ\ ] Woޭ!`Lqެ_{q;o5ޮe[ T1[7H”~ɯMo:0DCGGgR#d\tzm:zOV~<[xKgn0`nTg'~:ơϺo(If{'B8 /~,`{6(g:1o,RCX5RJEQmA ?lCh#yC;d/vpV݁s=Rt,N.- `/Ō=o}.}z1̌˖+5w+b+O>e˴Pnі6Sj ]ad4χ̬xYnʝ/iww+g#Y rdOlӛ!u+(M͌3N0Z27i}p ׷?5JheoK)Яݗ!9uk.b-]9f۟CJy0j"a7ICdƆfưgl jf!mz3.ue{!`"P*+Uz xW坕2oW;.N[PC!rk5W!$5"4Ì7H8%_Yyow˽WQ9u7xs;]D~8JRz}Fk_^X|e+7oj/ש͛nOK'*oT,>Crl_ߓ !t!" $#gp|H\)Qc]H@ui'9zq.1PhR"XeA{8(Y"?<HnCxfzk{ViCEdk RF{sR`WB4ǔQu6ͦ2>]𵜝r9wXunxsߙGo&WEj"d#(s{EAJbO/MO$*#XEx.48h2r_Jifnbd` ڹ/6Bd~D!ֺVO04.UB@odvظ;JS'ߡoR;qg9;mp([W̟{wCЖf/0+97蝲,|z"oPkoC Ën?o΅%1Ǿ[5{q6^[)Vd |QӽD}\)ˢwӾotG9/nيw!l$d]C6(*jrA1tªs&V3N-]m[音j1E$9+-@iӍ+ 'E/ /)ؓ~&)lŎ{m7b2ۭ  6/m&>Dz(XHƱ'g, +_*I6#\㇉+iT=  Zv?Q\?QTŷXM2u9Q\sqmUNvcwnE;`ĝpv= -3w݆u#J7}igyeʆjagR2]_g͒sYkҔy 4˚9$L"; TS̑ _Q-d\![S246~!4ڍ⩯C ƭS귯|o=Y6|QZyamlu"jTˀ*#"9hMwnt4AfXDi%BS5X `AɽBdP| ?\EnJ LʓQWyZVVqj~:vWH{"Pc m R5)_4U&|VDҍ˞LH !_{*Fv=D2.*jC))&|Ņ3rZnbMU'ȕ֟PCd1̘ M;Ru\}At~H5P?ek;ר!3hb@jjHxHEMO7D{D>AfzFFSY$HI׊"5ةZݖl'Ty t x|Jx"ڐP`p6"4YDp'Ie G1/6Z$[l#1%"][yL-NK+ ex р"~BQ4dۤ&'~-ld .~wz{oAn%ρgټ=f7_tR~ Uo[gkKC_gĥDxqG ,N=_QjcweO)] Қ4Jr. z#ΖLǐ{}J,Y,3Vx9];8N! c9cV/<:xZj}qK'Ai~Ҍ]Ё=8!+W9_맸7}M 2Qf$gRcF E uQOl KLP7ܨSԭ2zef s7;9Sd`a| HI*G@=HbSԝ9@Rga˄*#3 EMmEx/MԻ2B` dE0ؗc>~ʸ%Dd:%,` .Om$P.ˮQ1>: G._ndphzFQ6Y/_D_eH X nOЩr؇riMD]0b1l-bVRvdeuI&&PQqz] QW;Dha"/(v#aP:D(e)_Qc5r J1\i_w<1mkUq'f@õaoE Q\7ӫ 6nS>[vb~A5~q Y:I+-*G:p""9}4a3d0)DSahjX^:4rs{) @S~G6M5';akZժt?(4,u{6,\mL⣏|qyt%DԞ04G7^CS!79JMl4%;h)[MM5(HMTMmY4% VM N]ʢۛ=).M CS{图]yMhj|)ёES͈h 4ՠ }4GS}4uTOoG8aD:9erokq?<ā$lHvhkԈRՋOR!7}fgf^h&QV;4'MM\(%JֆRRVȡ=}(ՇR}(uTOJ@)dRMPj4 J (ի_A>3).R#(ȔZ{v|O[JAKP.C)=<(5-(7oLOpMMvAS#hAAhhj뢩>ÃAS{{Ը@Se uh*Ϗmn4%:h[MAQh.)=<4e7oBAuP*όm l(%:P[JAKP.C)=<(y]R(k_{9nئPjx@)ёͅR͈P ZzFC>C zjPGJQ@?aw"㢈tac*ϏmRMl.jFFSPT飩>꣩zjhGMu-ʗژ᛫]aTMJm)ёͅR͈P Z (ՠ }(ՇR}(uTO==pI36Tڼ`z"[X,\"&Krhl~,/yXgIטʧWW"yrK?N%qSŊOslk.͋TN_\r{ W(O~*C⦫(K'^W ya/ W3ܬc\z^~;Kݯ~}qʽg/}{W?W9wrO~Zi$M'edC"( mh;*#1\3R\ҘL}XgT/}WڭKv 2T~Td]!̶39s]CZjb|P7 ~qz+KoiZuӲ(/jmy Ӛ$؃7E%ޓ^L]rA2rUUAcL1n)ryR6ޫ%Hz];(Yc%xb㒋X6I7b8E$J-fw&k=2Hpv pOʅ|(#PV3_VzNuLr7ev2끪W>|r$mi=˖t ) Kk޵M9^ ,@M$RT2Io4R5ڒVNZ{*uŠ5jmq>)ɲWn[jFarޠŐJݒA F+V^zdlI)|Ε_U~Mx _Wr6(,1m2܂걞_FBo XYd`%}DqE&[eM/B 1&)L)>jNB^րHzy uV c@}zz\;wr'Xti{޿|V~RPtA uX:Gu IfB<]#ݵϿ~3>2 ;:6@$E+wzPV}qhƳcyÜ{eeKȶ9jd=#ǞM̳4u /=AeLJGYvoa!nH ~(}\*z.i7r{=]?Zh)[X{GrB J7"ფ&sz1Y|ZLbY\3/3͙/_̠#3X7Sie(K9*VŻ\,)ˁ"{'-5HAa±zA\̥|Mu F}{!lXvE쎩8cSEkFA \]+ 5갥ijT.IH}1`Z4^!Y'68JXFoDxRHdVEzz^(hJj l=E9lZ捂]dtԸo@Ubk%/^0Z74zSIH:璦J؞gg $VB|Dc#"ƾ:e9WBeiH>>;-QlX$}Fs_$M-] E603H =k:.#)l˵QEdžZVZYRT 7pnD9g>X.-nVjj, +fa[\Kq&K_w