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}}U߲|">׆NiW8:EX{g\*Iu UnڗEtTeDEL'˯pT4 M!Iթsg}~{'??xF;Bz[r{4><̋4#Ͼzo( Qq%[H"JA5R-d$N y~ǜ┩n3;JF^0=nGKoco7jѽhRy][PJF-{+I5GE Yb*bMBS$+JESbZԢcZYFN;+KOZfR.W:jgլS40<޶eGw Zm{Wk[=T;'+qo+תwn<.Uάܽ[y|_jׯV?8rLUOn'4;k%G7 ǥ9t [Y;v͓_5V~ZuvʝW] N^ewTtY,!vY3)-ht*痫o\$yX8kF5%oiFUS=6N`^{,YЍ#.)Ěau^&!!vv Z "RkHR8QƩ?FŶHXs_*kbDGc WԍaTiN 81Mv,?llfB%fE& +X*W+drQ-GiZ,xl= }j,˥_̨mhNsLh)9[0!OK!{`zS}yxO;5 ,)!ݳUx9@ ,`{M|ȅaKAj4Dzeu~;d`vaPKw&]𕤄 l[ߩhb"`o~ll6TҰGl4JJaӧ&am }7sʓmbjTX܁21코F XkSfZvGX(hu`9-CDɈk DP0(‹%4RmgHYn<[Q lXy֘y ;B31mz5i86\q2$1#bx*fhN\3f?h4!abncSR'&&&]ccJD#fߢVr`ffxZU>Ivg U{R/)|k:ID[LߘIEy6LC*AGL e Wܱs<ͧ$OH2XukyɂcOWHٷg&X)aƲͶd\Γ̘ESuzߺ-"^EG6D17ܓ9}^#ŃzN3y-~ymgW௝[G݄vQ|)ppI5]$U Mk3nLvHo.T[Mo$l,M IxĎ]kzΛ8oΈrkޫ~F24( `5չ-IXA[W/DO\"=KD7̥ lh@FI: v] µu6!agtbWP2~hI)X2S<3$kPFrlk47@F1QH܍^d 9#N̼R!)cO 2ӲGZN/%3yd"%lS xW47i[/rNLJyKFn^A#-9^CFyPFb٢NYG$/ǀv}3vzs;Fv,[0m Q0q.=I?Egы?kgإrA fQ%)(ZYf/ŋƴKw"5awy,K7!xAO \ E<܁} m'!P=xO%A;x{[-D_xgvp 9aG2EhiK$8YƩ$a}6HL َHh|O$Ʀ\)j`9Qҕ[rkF@W>PYGz2Y"וJz85~m8S7E>>Z}<:IC[]uڧQ"滐|*$Ęj!t+GHᬔ#zl3F[B;Ke[ KIJ_K+_}Ct+Z:3z}:yos7{LĶ>Y1thl:Tz ƋݺW9yaSάNU~[9wgK{Cf3b=H=B-ƣe;67gI<_CGZޔ5tٓauda썂G0Փ?V+?^8s)l$զ8*TyO&0S*^Q}U݌ޭw7]P:X#7h#cy,$04K?G|tY꼦/|RB?Ko^2;q~ '"S>WM7To6=aJڟf镻ቶIw*g> Y nhOl˛ut'ڗ@b<13;hD,*yWgOU?[v9\TގS(\;.S_K^r P9w؀QR/=-m ϞcPŭ*֣eUܼ׭z@GCGe[ K=ƾX)Z@WHOT6=kH~v[lԍiwJƇPQW84xl{?SfOVEi^b{0~/5/8br|Q=TcQѸÖ  q8~Z~c~OML8ߎX+w?~2oWۼm_Pr5哗!$5"vƌי_O0%o]^u7R9q!xk =Kft_zSzmڱKP#]W~:WYvJߨy6||mX;}YSgWY@I]mL* F jAm0?M/Ti;-i݈rq&t#P`!Q.=CJdd@r?0"u):Ҧx4sOU!n1>ΦTw*翖(pnNe%zg|3q"5X78ק{Z5/~, +>Ӯx`G9./n؊CZO\+> 4\m^5U$U3sdCdd+A6(dknnk= e Ҡ"PPPB eNҕҍ  x#Mc%/>ΐO1v{Si%\y*)څZMaڪOmT}& ;Kyɘy*h9,2O\0eGTd>"\żͱt˲gDsL,< +"eGEpdUOHlD*OC?5'J9aXp0 ѽz2Mfq76x1YAdQv{+H_˧* _#XciJr?(W5 ^,SzW.D@M{7[F\sH=n}#']B(g@ÍlD% X Nc( y$Q+g(pYBqVSi8r{kcq7uG+MQC)R%s.@%?/Njj_YI1Bu<` ~t/86*.8P0bnLbW"1:DtbHDfg4.r۷jGw~ )Ljs^d!b|a!}]\˚-׽,-o:\-#| ;0C;ݍ΀N'@r؅riND]!0bA͂#\eʳS&+kH=0%l,ͳ{uuB +&|cZjIZR  4XR,EU=_ Ŷ]߽caۍf_A|oE{0ӫ`nG>[vѢA!D&5~~< mg6HܢcM*"oO!2NyyB.3&hj4M 4U'7[Mar;h5ة[#-;zDSLQdhj&M7BSA,\}Lcb|I9Z͒wWAJ 1v 4vV h*GS-dG6M$bS)RT&M)T^yoWvM߅W/׀nnu45UДƢVDln4EjRڼh7# o7ճsSS6"sVrgY݀yM\_.p=7W1kHM)[GfW=]I/wC3Ym0ГЎߣ<-S폲d~T* K.UW~P;w)I;T>}@MF+ivE.=/rjOk__];SrokoT?Srrf2I:M:ȆDPhѴ45\uV 6.eaax=6̏UDD`H|gG $KdDCJRq?Cyem'T$\T]ŕʙۓަl,NҐ؈#+,oײGnaUOZQY,ЭIO1%/NmIe+'n;Je=uŠ5*ihq){1FejTWxfevWݨ}Y[Px8Z TwnT߬}cVv7v~xо]iS{v@Ys:#[OY9'& tVfZب261{Ą#.zrﯘ!j,YPYBߩH^tbdakeqų%d[ֲ@ۂAcG5cq]lfݜϠ, i05;V\$X?WU>^.L57Njݎfli-XQHcmAR9/b>-Y,iVɗnLzy3Q/n/wh@HNY E8)X 3\ʗ^ёxk/-Nݖ<4TX.[3d 55P^s-EuHPrHOCAPup]XFkDxRHhZ((Ӱ|*zV7(l=8lZoA3浂Ydtոk@֊r|Ղ׻%ƿwm9ϬCD(48fqRAb%t#(Gb+YiSz%PZTņEj4^;$R$N3IгeC#]%ateb^jZJ8Um(GRȚ=:K}ʶak):iٶ{UQt[3F1,ZPͲBg-MSS9oyM) ̢Rj=ΰȰʜ zQ(♒mfU#hKdsvjb4l ^EuZ *X)D5C@f[<ä)ZQSؖ@ )j:ͣx"@L1s6b!?`/