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ۘn sy5%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%4mcY z@XKQ QvC}snBhӞCɒ3}ħ6r 5vȳB
^UBu(b@4X Öhevgu3Lh;#3I&n}"JdaF~Y !0 UU[:M|Y*.u GFQy%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-[ZV#Q#n`HuIW=41b>?9R%ng>%ʰZN` @{$(.*9\I:Z䑉`GO.^_K~/)})oL%o.<1[RJeKLpj a_
0"-ʅ2
4g$H4~<:ϵ닱5۵fقn*Vkw$seD/\۰r̢ KS.0Qp >2in@X_`sF%e XIWVW*o@ _~L'5Vsj>mgs-xD.n>Uomtp~~zO$`De37¶d Җ ұ?4L0iڟ~f_ J'̰&T߽l"MeʩzOzwh!lX
ӆS4!uFZGEp鐾y?mq lF?+0EE:XgbF7!y|4gvɲ&P} lyÇ;vGoO aJXz`>LbHYLJ;_ `0#Y hnhK)oˇuԓd,1ff11~)g*߱UtQ{2+{G?z 4`>OZKα
c_8[QR DmO?ViB *{Bk Y-a@a %!`"~I/*}x~E& 0>ثo ٌl|z~rERTPB233x>FՇ|PXGI=ƾϐP֭}a@H;A ztrմ;%C|/PDwݽΙ=&[+ǿ ^b:`IGyrM2,<ڲCKtI8/
T3 J؆^'J/ Cg3SS(g$)vml kۍ[.w|&j5 3jG3.s8=VǥeC:\GM.0~چjSN7Tn
?Eo:EAcfL8̪!(5|ކ`yH ^ N８f(<|l>SIGOMD C ʮsFαލ-ʢ$IAf[q݄ Yps&b|r ≣|Ӻ{% ̲c~E'hs=(bMwzDʅB`ޮu`u&Qդ3OXm yFot
gi>Ƀ
_ ߩp^h)O{88N E-2U1Inzb\wrjJ؍`3Glq
`u8d[z h|Nb |̽-y1]~$JC>Aue6;E|gg%+畼O#Jv'@] MG;vw#!N3#|溑&q;PDbO҅(UP̒8L?2W=a&OFY# jR Ewf6qG 1Ww Q7h/a W̼ΆS{~N }|e XѰ~8}w #ms{r\^?z j`աŵ/ث?j_:oނ?WVO O߰אַ>K;%~t^Lɠ % :(
!L*=Y1S/`HX918P*q %Ƶ Í@)DZ ?c~F驔8:,q~<Hg=8~ -gfXM><"[疟2*m XVCG,%ԕC:fCܶ/~N rc9yp ǁ {EܢHMl vlS /AťA鎠_X`q<K\7EvHZ4v~`U sֺVܾ4.{H@z ~i4us pL&vݴ]^ 4gg89n uk l,t 4DY8 5 O R!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%4 u/eq`-=]rG6Nz+ς!
M[SA-Uts?!p LA d|ͅ1̻陦E m
`
>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|5 e~1FQ>.'&yv#F(xfH[Q xP :"1+,e]Dxxi6Ъcr|V-}N2"r{ <
B qsR?G MG7-
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"
rV b"7W_uM*f.'RU_*FfߦOQ`Np)r` `6+
JgZ|*
Ih?i.z 吕!iDr Vq)XX
2g
d57;E xOCD2oRǍ`Qpn
)$7kr 8){>`֢ 8.Tb ryLQ60Lp@ɦ zOF?ğuG!o.1҄wΙ'-٣| F#݅>QDnHѝ栮| ,
y W2+d*+B iOSMSޜ1YR TmX R2,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
2DSC45DS 5DS}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'ba4YE CSDcqb :!D F5ٓDrZu bW+'?~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֍YX 3ӣ(*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֩)KfA XK/~Bo YY`n\Pұ\Ĥ'"d=c^
eb:L`SX2BҋuԦدʖ:HS3nA^w@'?\ >{vx VM6.xw Obp$5Gu JCJ& z"Oo_O1 _1 J<^(q>+BޚM/L},R y XY1ceT|~EARAsqklV˖&Ke9V!d6"Fbe"M1V\htƋsVA'Əyh{WԤ!/T1jJT%:=c\ V+>>!vw-*bʧ;;Qђ Gwƃ 4*:inǰI T.I@y ]c^ը2F ;@( ivd]E2Ur
4(ڢRK*w
YdO/\PZzD7qH:B-K/A*HN{#L>k-2)r^fӀ'5Jc\Z z U(..jQ _(M-= A gP=&#@ٶ2$
UֳVU;R1xp)q[%$ʱ'=(Id>kB]>}E XZhv ,)~ٰ$Ք`4[K2e,(KRqWJN,KKfJ+)-(`% ")X0PMVdQ>$HF