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 =ޱ+nPm3,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}t5xyvWTv;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أbKbigqB&z>2I3z$<ܰ֌amaX5oXswi/ssBoS1+gi3{>5j=](0l`/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<9jz襨aUGC0'ljbv6ߘb+oĤylˈ*AGL g Ws1s3 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(Q91kn+iDS$um 2BP'fG)T CPTY#Gfo`⢑3EqIB?쫣Lq+n2~ϨK̢CKj3Q^1׌inuo%a7y*+s /?"§37s7 d-yxX/n~&5>Z:Um$҃5=8#;*DK[$eI?gdĴțۈFljlWI31-].UN~hBjه7C*ROƱ2K\xY׏PWV~;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}pu7⿦v4JheH)Я9yc69b-]9F۟CJy0j{"aI}d&Ff'gl f!my3.d!`"P*7yz xWǺ|#O#n-i<[CXK&ORQ1j\=p.IhC*T$?!>8\& 1eu8#ʻbAw#(5w}29EOnN4 BOrr |L0sy V{(Ēq9|~L8бLg _ĪEWF*GPy>~ECvHP' 4,O-f&@'q<&SF!\^0AH} _jIs ZKB!8j~`"Ѧ031!F#1[@a-XN얄 压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 07hoo?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#]ncM03?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"kjnYUsq9̦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<?eYXSIa?Lr]LrUydL5uHXK&k-J6s̮;q-hY07G.UE:ǎ3E {t#?" TY=_[*XܨZҤ!dw"M7f9Z2@rTv)V[ h2B햚DA8FdvEVbFut$R^3ernYLoCw.A瑑y٨TLρm FkcOz/bE|v^\f x:lO%6rca(DڕەWߨniGݶ,37v$4oNh]"\fM7Ojrwr&PKLF{cY;F~:dW vxVn٣vyO'?Po׾k߻XG] #.%6ψ EbN6gph*PDh[i.{ LJ\քmS<dwȽTгF g&$ݵ>M*EdjMMewUL#ph'b 9\0Ch%FZΫs-!.}"I3vAK(\$鮟󞧼Wf`<6e68OuIjj1Z54pT}?q icFe؜nn+;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]Uqi 4\/-N( =hvL%J#ؽ6+ݩa`jSWBnns0&`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ήe݋A$v6ERIl.jEFRP5+I Im]$W?@R>z7Hq{!EMRa7}vlS0.`JtdsT+"6L5iL 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|XKMRA_^~nG^]}ִ+iM0M=H2kx31[|C=(uʻ,$K)WY}qOQ?-.YWKt믭]y7QJ%Ql ꓲ o&qȎh[L֔{d@rq PFD)z$Տ?g(/޾^rSg=PuWWTNߞ6gv򒎁V^a){߿I"oQԑ3kEe2?nZ&?I*xWwjK*[9ycV*XN&fKԨYePݻȠb&]vrf5KyyCF&uK/\yꉏZ&(Ohʉ;Vo~Ulj6i;H͒W}]o۠LiNlMXt z~ Q&YGC3`ekN"y܄E|VYS)KPBL l 9[Fz4h4:KZP4騨1\_yzZ7Μ ~{OO*}ܟⰣ^ uX:Gu J…k3fب661gĄqcn+cCZšO J s>MFFNW .!z我\ {f6iXONbM:4dl~gHU l'Qr`빤}dnlʖK8KuZ9 $5Ӌ"b$|0.ng|1^͎bLqcT, Zr³$,@,bh" -s1"6+>:!b텰%b;itX.[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