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` kHDdLETe: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@XKQQvC}snBhӞCɒ3}ħ6r5vȳB
^UBu(b@4XÖhevgu3Lh;#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.jhtLJLUZ4[³XXlsV
cm >K5E%.ƫ%3+aqQL5T.a6Վx'}T:Sh8YfIQiqTF%kT2wK/p$kcv>l5bULR{~kV{P8Xy='=Z'Ъ-&J]hHݎHKYi0EL=5~|les/VSrȱ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[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?mq lF?+0EE:XgbF7!y|4gvɲ&P}lyÇ;vGoOaJXz`>LbHYLJ;_ `0#YhnhK)oˇuԓd,1ff11~)g*߱UtQ{2+{G?z4`>OZKα
c_8[QRDmO?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/
T3J؆^'J/Cg3SS(g$)vmlkۍ[.w|&j53jG3.s8=VǥeC:\GM.0~چjSN7Tn
?Eo:EAcfL8̪!(5|ކ`yH^N8f(<|l>SIGOMDC ʮ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#jREwf6qG1Ww Q7h/aW̼ΆS{~N}|eXѰ~8}w#ms{r\^?z j`աŵ/ث?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\7EvHZ4v~`U sֺVܾ4.{H@z~i4us pL&vݴ]^4gg89nukl,t 4DY8 5OR!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