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}{Dd9Nfv~68Ù;{,lJlHrwZ@g2@3! BH]δl_|U%Y%?:vf&J]Rɝ_=!b!#3}NztrsS矏Fi (ST` k HDdLETe:L'τkqwzD%#/N!yEΥwx!*Z#5tYfI& eQUPBEŒC/) edRef񥥥&ir,㪖SJң^˕V(ky9k  RRۭygoUήTx~} {CO]fd[s~}*ZsmeOn'3k%K5ǥi40[Z?~ui砬v@ϫw篯^v'9yEІ6Ծ~ͅ7.Ծ^rgoSw*_nU9qʿV^mۘnsy5%nU՛nGOVN=жnZMdHʖ\'!ؑB'5[%O.\R2jQ{yd\`#%#*xKj8gl󊺐ׇJT(ˑ@bM(s_ʐ\fM3nZ%d(TݛyEIjRK9fQVV9Uড়(F6 eXx,;B= 072n!G̸{ ;`U\+>jƅiy]7EeA69IO{ԯœӉqL*ˌ#1$z3ыy\@.Y@QeFBӕL%WXJTRHKQ%4mcYz@XKQ QvC}snBhӞCɒ3}ħ6r5vȳB ^UBu(b@4X Öhevg’u3Lh;#3I&n}"JdaF~Y!0UU[:M|Y*.uGFQy%dx1M.,[j<9dS>9_bQj0/?XlwB.s+,O!E1ڽON' ^4k{J,bT ܁ύ=O沖M%pER+ xZ)1U3nz좆Q޵%1}i4gU#'#4HTvf$#&r.#f ԏJ#RON&&f& J˖&@)h*qg^'L?grVK˴~H@%fn&lͬ,)[,tcVzx|r\~d .* ˳٣yJr.j htLJLUZ4[³XXlsV cm >K5E%.ƫ%3+aqQL5T.a6Վx '}T:Sh8YfIQiqTF%kT2wK/p$kcv>l5bULR{~kV{P8Xy='=Z'Ъ-&J]hHݎHKYi0EL=5~|les/V Srȱ3DآbL+ZL=³L)UvƳYU<_ .dg0C-4Ӧw^qu'׆KFkFr0iWg3" HXa@Tԉ陙Db^jzhQ`Ҽ{TUJ<¾Ì4JXͰ*٣T! hOt1'ėSDDtLO*gMה4<4 [ƣj.GŔC#Xn,:9ɂc>tO=&X.aƲζ/P牿d\|s֝e ~uWe|KeފbL/'s^Gˇ՜ɋQSy譝gO/̛GѽfQ\s\5D=IrCȹS-җ YE}I9˚E_T b^!@%Jf/ l܏ͼ^*]Ъ>OQ!x]Եd\31/$Ss,T$a _]a[~ijg>q 0"@7ѳE'؍b4/v&LN-ð)q&&kx%ciD+%3e3a H-V#Q#n`HuIW=41b>?9R%ng>%ʰZN`@{$(.*9\I:Z䑉`GO.^_K~/)})oL%o.<1[RJeKLpja_ 0"-ʅ2 4g$H4~<:ϵ닱5۵fقn*Vkw$seD/\۰r̢ KS.0Qp>2in@X_`sF%eXIWVW*o@_~L'5Vsj>mgs-xD.n>Uomtp~~zO$`De37¶dҖұ?4L0iڟ~f_ J'̰&T߽l"MeʩzOzwh!lX ӆS4!uFZGEp鐾y?mqlF?+0EE:XgbF7!y|4gvɲ&P}lyÇ;vGoOaJXz`>LbHYLJ;_ `0#Y hnhK)oˇuԓd,1ff11~)g*߱UtQ{2+{G?z 4`>OZKα c_8[QRDmO?ViB*{BkY-a@a%!`"~I/*}x~E& 0>ثoٌl|z~rERTPB233x>FՇ|PXGI=ƾϐP֭}a@H;A ztrմ;%C|/PDwݽΙ=&[+ǿ ^b:`IGyrM2,<ڲCKtI8/ T3J؆^'J/Cg3SS(g$)vml kۍ[.w|&j5 3jG3.s8=VǥeC:\GM.0~چjSN7Tn ?Eo:EAcfL8̪!(5|ކ`yH^ N8f(<|l>SIGOMD C ʮsFαލ-ʢ$IAf[q݄Yps&b|r≣|Ӻ{%̲c~E'hs=(bMwzDʅB`ޮu`u&Qդ3OXmyFot gi>Ƀ _ߩp^h)O{88NE-2U1Inzb\߻wrjJ؍`3Glq `u8d[zh|Nb |̽-y1]~$JC>Aue6;E|gg%+畼O#Jv'@] MG;vw#!N3#|溑&q;PDbO҅(UP̒8L?2W=a&OFY#jR Ewf6qG1Ww޼  Q7h/aW̼ΆS{~N }|eXѰ~8}w#ms{r\^?zj`աŵ/ث?j߼_:oނ?WVOO߰אַ>K;%~t^Lɠ %:( !L*=Y1S/`HX918P*q %ƵÍ@)DZ?c~F驔8:,q~<Hg=8~ -gfXM><"[疟2*mXVCG,%ԕC:fCܶ/~Nrc9yp ǁ{EܢHMlvlS/AťA鎠_X`q<K\7EvHZ4؂v~`U sֺVܾ4.{H@z~i4us pL&vݴ]^4gg89nukl,t 4DY85 OR!m; D=4#FH34ucYPO{O{Z!~ǝGSæx&d_]wj1X^s = HÀ@,94JV{.!Xe_Uv˙\q >%:8 +ժN:y<]8]wt`)]&nO>]r7s}=;\ׯ]sd8u˲]wU?3 ,M4u'?1LD'T{~~D$p?i}95CnYk r5nt,0`oםXJ>s_DM.[$l}g"Lq-ö!78HޥD׼ݲ,,c¦pBv%4u/eq`-=]rG6Nz+ς! MA-Uts?!pLA d|ͅ1̻陦Em ` >o"qZ0G]%G m^-C uuҦ)(t˫-*JѳP<NϻeYPqn8I?rFE rv!St??a|a|^]&e3@v9˨;p=l 85s)ԁa>2ظs8h&XZdYϦ.p5<_cS'qςJ E UgR :e|5e~1FQ>.'&yv#F(xfH[QxP :׽"1+,e]Dxxi6Ъcr|V-}N2"r{< BqsR?GMG7- w5~]h\SA!F9fEԑP'#r#ï$B+feo\%~r%ù HK9} YrAsS=Ⱥ)yc@g[)*,HNNJ8t#ْ 4Kpc,6(롄{C;+ r!WsDFن%Dz3s3}|tU|^{Fޮ{ G~zAc(7a0$YpE%w(Uu</YiLS-tÒ5)wa4 Y^a\My*u_gv8juMsfM  IG}W*F=} MF:Nsˆ[&bnK2G\c^\f |wܡhya!IdK eLo]]ߚeV߿ [yzl eyDܒjIMOR܉wo.]~wz{gCynۛ+٣z:oǝ w?YQ;nn:)Jl>lvʨoؓ5 do) 5QR$KB"ޢ\(6" rVb"7W_uM*f.'RU_*FfߦOQ`Np)r` `6+ JgZ|* Ih?i.z 吕!iDr Vq)XX 2g  d57;E xOCD2oRǍ`Qpn )$7kr8){>`֢ 8.TbryLQ60Lp@ɦzOF?ğuG!o.1҄wΙ'-٣| F#݅>QDnHѝ栮| , y W2+d*+߼B iOSMSޜ1YR TmXR2,i>$읎زqګ:hU\t`|) '>5PL8שXԃ.jS1bsߤ~wOR# "oPSÚ*<GpM=tP^ 45.Tۀ !ݦh =ДېDShN¸cתt?(4,k,\}w ~MJңXT)|c4'MhjWTm3M9 T4ՒFS@SM 2DSC45DS5DS}Nc[Kߞ M BS{/}>]yM 45-]؀ئhjvAS!Z1h 4դ C45DSC45h\`"fmo&3ߌ/TCJ.PJ4dsT+"JAKdPjJ BԼCX}v/^C.3).PJ4dsT+"JAK<ެ C(5RC(5P\` tT"9M SA]~lS4.hJ4dsT+"MAQghjMє s7x”㾹rڥئPj8?Ol.jE`C)h)T J B^A)1?7'g"mʻ}ET3jAgEJ'ba4YECSDcqb:!D F5ٓDrZubW+'?~pLЩeO2tm!ͳا/ծ\}%1붊E FHz?=zmpBрY*hXDoUdI{=@ Iy*R" n,. i^gm ,dIOiI4]O.p=ĥ3M![<#ग9K/e& hǟQQ*F GYt2?( .+_.U/GgҎs7.Vxp9^/߱?s ~W{Woا}ϫ$__7(#AahEP(PeS@dД|jak>|)[vHpԳ\pK&"J a֍YX3ӣ(*X/Wr 4=EވM"c(Qט)L< {\oUz$U kwoq=&q!AkϯVVoOFYYqCAb-`_#RK Dn]/bH'uIh}݋TKu%K(쬃%M{єɢ7NWZ4O+CYRh|AϞ>}>Eǭh(_h +kyUxů+_h_:эHC֩)KfAXK/~BoYY`n\Pұ\Ĥ'"d=c^ eb:L`SX͹2BҋuԦدʖ:H׎S3nA^w@'?\>{vxVM6.xw Obp$5Gu JCJ&z"Oo_O1 _1J<^(q>+BޚM/L},R yXY1ceT|~EARAsqklV˖&Ke9V!d6"Fbe"M1V\htƋsVA'Əyh{WԤ!/T1jJT%:=c\V+>>!vw-*bʧ;;QђGwƃ 4*:inǰIT.I@y]c^ը2F  ;@( ivd]E2Ur 4(ڢRK*w YdO/\PZzD7qH:B-K/A*HN{#L>k-2)r^fӀ'5Jc\ZzU(..jQ_(M-= AgP=&#@ٶ2$ UֳVU;R1xp)q[%$ʱ'=(Id>kB]>}EXZhv,)~ٰ$Ք`4[K2e,(KRqWJN,KKfJ+)-(`% ")X0PMVdQ>$HF