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 }}wENv-rb;vll`rl> g$I13c^q@
,, K!$.w-_F=Ҍ^ ).4]]]U랮 ;? z\{Bz3Ϧ |ưrܳzC۫ r3+xNL+L,e Lco,Nx~]/>wpz8
=ޱ+nP m3,O3- yZV+.vp=?Uv
1HW4{^i*\\\LXzш,%v1iZ9X/=eϘAurKuxWY9Їߩ^=әʵk_/-\;zv՛> YN ͯ'N֮.s嶝9j,-N
a1W*qàߧ+_5w{md!t!m0D$$$mva4q4IRIi>F5=j/)^/bH
^Ţ05Rvt~0h;vu6;Ğ~-r@lGm=qcLwzIT6n<;CX}t5 xyvWTv;ug\naV0-0ܵOAG ? /`va'[zJf}zBwL
H(%AO9#aZ.v~g@͌1];!f/,jxdh9lARuEy}h_Cam xiNëʙ.Ҕxhx˙<(, RcQd!? 6U8"h*YObcjmLiXe\ kq%3>KأbK bigqB&z > 2I3z$<ܰamaX5oXswi/ssBoS1+gi3{>5j= ]( 0 l`/KNtnG)J`l4Z*_
:\be}/V 3r(`(Yq!(34
'Wy6{Sj(ˍg <2^ 53ϡCFZh&Mϼ$u '߆k׆5fd V8V%,KӇsc&$L0MUC vf*YɉTj. b9h8k<9 jz襨aUGC0'ljbv6ߘb+oĤylˈ*AGL g Ws 1s3
LyX>,tcI,y& ގ=vP{Sځ=?7?PJڍ2m}OM'9/95>34:V\:l K__wjD8@@u`gj ?E]L%2H3CnhZ&9` 4B}1s>Rfѻ$¢WH(@^O) l2ݼ]*]Ц^NQh!dI=HƼ$ rE4c!:wLVƾW|ݓ@
SL 5 zj$XS.dIVᛂ:
(s*5FPuEgZd5)Y3(Q91k n+iDS$um 2BP'fG)T CPTY#Gfo`⢑3EqIB?쫣L q+n2~ϨK̢CKj3Q ^1inu o %a7y*+s /?"§37s7 d-y xX/n~&5>Z:Um$҃5=8#;*DK[$e I?gdĴțۈFljlWI31-].UN~h Bjه7C*ROƱ 2K\xYPWV~;uSQ/[ u{vvbkKоNd<5J_{⧓0
& 1摅Z]݊l~3R8(%bN-daKdgl˛!ut~6X{aIq*CqەS{7ġ>,)=NU~k/[91aHB
v pK3}s$L?*Ϟ c_4t||65>FoTOMgEOVꏧOs04ԍ1ЍW5ӏT8T߿U=Y
%lDg=ATqO <ڻ+o9i/"5%_3.t0[4; 5oQ6~*ohEit7poVʼn9 ,Sr1c`#\?
eeK5cȊOG ~BeNoSGYhKFBQ]ޞ02Z]}fμ٬c7t֗p}Z{ەt9T͐:ԓ Kf2N0Z27i}pu7v4JheH)Я9yc69b-]9F۟C Jy0j{"aI}d&Ff'gl f! my3.d!`"P*7yz
xWǺ|#O#n-i<[CX K&ORQ1j\=p.IhC*T$?!>8\& 1eu 8#ʻbAw#(5w}29EOnN4 BOrr
|L0sy V{(Ēq9|~L8бLg _ĪEW F* GPy>~ECvHP' 4,O-f&@'q <&SF!\^0AH}
_jIs ZKB!8j~`"Ѧ031!F#1[@a-X N얄 压8"n
_01 1C_H [
}qH; ]yWTO^bH(Ǔl20`
nd$ᔼvio/w^D#ڷ
n:+ңJ^: l:}yn+>\+տ^6@@?UWN/ Vz
j_c ] ɞ W8*I]1x>vZ?V,Jl<݈sB:8*sO=4q}f&%K'ÑɓH
g-om8b*m
l[Aʨzwpz/b>
J2 ΦL7+羖Bq 07ho o?HMlej{`#l]@0})3Z\Cp} o&x4(GXMe"iRE9lG{-HmQ{q>Փ36L >b >:Yb4*M|H I} + ķ1m0n^~If!?ЖF )HR QwDaQ.n34Rx^ӡ=4D̖w˟yAmY& k#]ncM0 3?Eg $=Ks V?.8wmQ`{mklͬ4oEAW&*zU n&uD'e6?!A+o<:]th-]^,:^L
͞W`_>]sd`лeYT|
:a^ :]mh-]^tk%<$d|s.|/A}ܚك9}ܒLǦpE"k jnYUsq9̦c(t| ZH:Kl>nxk龹/oM5:{y1eYTMJ}~ 3@w=ʡtyqg~&VIKe# ,pFTQ yܤV{ķNڞqj
U)"yYX"DC=2`n '\e0,,!-.n.xL|+uH eF.vߛmAn5Tlw=!ut}i͔6&}*ıH1E<?eYXSI a?Lr]LrUydL5uHXK&k- J6 s̮;q-hY07G.UE:ǎ3 E {t#?" TY=_[*X ܨZҤ!dw"M7f9Z2@ rT v)V[ h2B햚DA8FdvEVbFut$R^3ernYLo Cw.A瑑y٨TLρm FkcOz/bE|v^\f
x:lO%6r c a(DڕەWߨniGݶ,37v$4oNh]"\fM7Ojrwr&PKLF{cY;F~:dW v xVn٣vyO'?PokXG]
#.%6ψ EbN6 gph*PDh[i.{
LJ\քmS<dwȽTгF g&$ݵ>M*EdjMMewUL#ph'b 9\0Ch%FZΫs-!.}"I3vAK(\$鮟Wf`<6e68OuIjj1Z54pT}?q icFenn+;4Sh@lnI**,NE3"%]nBuLQwIҟE2r@>$xâew:T"Q l?͖d=(!+ATľ V-! / (aKp| ewjD`&:p]vBqi8rqr3c\HDD3R}z"J(9:bvR[GY${4vC5Wk:J1#xX/PѽxY@7S1%qJIsgFgSSё^ I'ƎM$Jd5Xp"OVvzHO7h5GP<&2#GȘmg]քO0_Zߒ:@Ym+[0GAwCm>68GW>*+h$芠/ gDHlЕQ&+kH=%+lʵ3ի*T:!g
C1U|A1Y$D~φ!B'4LA2 !TJ]M ={#Kѿخz]U qi 4\/- N(
=hv L%J#ؽ6+ݩa`j SW Bnns0&`JvdSTK"4"=jRڲ`J@%ꭝE|S~_Gݙ|?\N
DG6L"bk))T L
S}5) =tUla^:0c8ScIUϟ\?F
14{B
ځݩmr`")P"62
} jHGI!F6|`JERQHj\ )^IyMvٓ 1,<ڷSH
J
$դ $5@R$uT_ I !?|L>0rg6ScLl.jESS& j`GL
0_>> Bnئ`jvS# Z`IA`j `j납ýScw|Q&; Tn~ـBnئHjvAR#ZHIAHjHj"ýARHk$@ROήeA$v6ERIl.jEFRP5+ I
Im]$W?@R>z7Hq{! EMRa7}vlS0.`JtdsT+"6L5i L
Lm]0W? S>z7`WQ'hԶ \BnئHjR3ŧti [r+iOXsIS ԋ(R!_R]Ѡ stiϯ*2kyiQ2R$t/*wC :-`Ŏߣ<iWD돳,T\,ߩ|v 6v,.Vy\/+W3ܬcz ^~[ >_rrl}yw*gUNO?sDlHmǠ ~2Ce$-]#&jF [)7S3^]*BuIUΚzA&ΏL"+v4g>std|XKM RA_^~nG^]}ִ+iM0 M=H2kx31[|C=(uʻ,$K)WY}qOQ?-.YWKt믭]y7QJ%Ql ꓲ
o&qȎh[L֔{d@rq PFD)z$Տ?g(/^rSg=Pu WWTNߞ6gvV^a){߿I"oQԑ3kEe2?nZ&?I*xWwjK*[9ycV*XN&fKԨYePݻȠb&]vrf5KyyCF&uK/\yꉏZ&(Ohʉ;Vo~Ulj6i;H͒W}]o۠LiNl MXt z~
Q&YGC3`ekN" y܄E|VYS)KPBL l
9[Fz4 h4:K ZP4騨1\_yzZ7Μ ~{O O* }ܟⰣ^ uX:Gu J
k3fب661gĄqcn+ cCZšO
J
s>MFFNW
.!z我\ {f6iXO NbM :4dl~ gHU
l'Qr`빤}dnlʖK8KuZ9 $5Ӌ"b$|0.ng|1^͎bLqcT, Zr³$,@,bh" -s1"6+>:!b텰%b; i t X.[3
jn2bi66^[ѺѡVKB!(:]chB
Uh%,#ŷc2YHiE>" H/e
MsZSĘI"] U}n[ذHX 9b'H[z@ĩ `f>4 0g:.#)l۵QEdžZVZURT
7punD9'>p.-nVj,
+fa[\Kq& K_w