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��}{wE���d��q.�g,�r�gl1Lg8g��N�{�,˫%��N�n�ݲck9$�<� �d3!� BH�]�X��_��vUu�Z�%[����DRwuծ]{��Uu����>y��9zH�9�|r���h�9}Vy���ɩ��iFF�}>�o(� �Qq%�[ӑ�cE��jd�#%�Wm{:�k���'Zy~"����┉����?}h��d�����w$����=�<�����_�_q��V�H=h�f8�n(EK�ӵy��f5jY�d��9*J�E�r�#fv�d�#R�4�h:�s��d<>??3Ԃ��Z���B\72��X1W|�2K�6��2��/�FiVM;%K��k���N^�������f���*�?�Y~�\���3�}��R>{�r�տ_���������o\)�}�����{g��_�|xOyY�� %�N[z��M���(y?F�VVO]��{�|�\���l��;uā�埗ʯ߯^��|o�z����7���䕗��6�a��w*�\^��R��啯WϮ���X����+��Me��~V�S��G<�|����o���ꚝ9�-̛V�`��1�W�2q����_�_�9�u{�����;|�l¤ tm�0�!�D��Ӫ���l�7�$�3�mfn8v��m�eg�(5\�y-e�n�-���I^�'�b�xQk� ^ż�qr05�*�j����gs���p��{��u:�Z��LG���S��I9�#d ��%7È���v��(�1k�;����i5�M'"A*MC�^(�sӑ���уf��:z�t�c�Ӈ�� D��f��k7�K+��*_Y������S��oL��}_S��)9K�mf�z/�8܃u}䑩�n�U�H��W�Tn��)˴m�mg!���-�XZ~:�~�9MIh�#�vҡ��qj�O8�Q���t$���/�4k!�?�ñ�+�F�8*���Y(�+�cm+��LӱK-Ə�q��:l���Ј�:��f*��X�-�WOy�N;�5�l^S����,����Z�� �G���c�aO����A(���Y+�r��-3KVZcm��e��G�>L���7F �r�$qobh���W��>.}���� @m��B7�1�99 bu�������~��LA������M'bc�� ��8�k�7E>�nBIA��������ܞ��Ml��p @������ ��u�f �sZV����9IbL;4�RK�|~���8��c�q1�^�������2ڬZ�;]�C�"�`�2��i=J���a&� -+�P̫�W˫d���r�Q-GiX���,xl>� }�j,ͥ_̨kL�hN�s�L��ZS��9��[��0!�џ��C��QS����z�S������xO[��ځК��c�ߔ��Y�*J� upmM��M����d�i�_����5�^ҟ��wǟ0������#��Z��{~�:�?g=?M�������K�>�{�݌�����=?+��\�jeK�v�� �2���o ly=�٤��:��Z~�cv1�~s`�j,�FVs�U� ϪY����熞?��T{�HO'���2{�+�*x��h1ݰ�k� j��SǨ�W��!f�f�4�j���o���9���n�ق��븍�Y�o��o�P�Y���S�7��aA=:���&�ZrLV����J�i��֮�oQ(��}�-$�K�+,Di��D���C_I�l�f��L*��������@޴&�G�G��������n�����2� ��0�`9�>\��f2��EœJb$���G7�)��T��ʽe;��JME;K�I�X�x�i�t1^ͳm�I ��R���b-n�d�'�R{�i�u4��C 5�L�/^��?��5 ��Q��F��-̨7J�^Og�Ԡ� *s��1�8��=���#•�����fS/ ަb��b��Wt�P��8}��$�-��v>XsrfFy<�M�U�XL-� ��H͎(����KI��0�U�L=u~�ll�i��}�/���f���2(�7D��؜fِL��� ��+z�B�=\���T�)�B�r�ل,��*��W`��ͳ��s�Pء��i�3������g�ψ+}��5fd�V �8�V� ͉k�̟��gS�MH�Xa���@���f*Y�������X"�otldd �^jx�h�`�Ь�{4�֊��,U��� �5<�JX˰*���Q���' ���l�j�bv�� Y�oLOG���7fz�#�y6LC��*AG�s�H��@���c=�g���67���K6�뫎c���n�`��ؓG�g�<�>���O�����:V��n���os�h���T\��s/��)�=�23 ��K��-*�s�;����+ym։bN�o�Oe�9�����P�ס�����:�*/P-s�_;�\�GO�����vA|)d�ppQ5�:=�L���ְ�/f������z��[��s "v��G��Y2z��X�� �(��)Q3�8I���2�����3�E� ��q��)�ߜ�1�OV�P>{s*��ɘ�.Ӡ��s,��T�)� ޹��7{R�ʖ�{�.��D�{�T:��{ ����(`7Iv��n����0Yr��LA ���(�s21BP�uE���cD�� -�N2��J��� �3(�P9�1���kn#�Y��G�F��)w#ɚ�sA���Ej@��hXe�}���`�p�)�f-mZ@y����P$ \�2z� .�P���-?&Q\�f�j֎gS|������6���]��xR��"�������dM�F�䈕lN�@�#�m8�7�E�95_�F�ue���ca����g����!�n 7F�Lm�ur��3�C��J�M[�`DL�x�r=�KϨs���c�^��~������]*�],��Y0�z�I�',[�6Q�QLzt�S^m��V���^2��V,��,-V�ܮ\y����D�T<�'�j#_#�� ���E�{�;Z'S �x���N����7��F՚tp~�>�~t��Q���i���gt>��"fM�\��J8}��ج���i�7עn=.�3�� O%i2�;VJE�d���W�^>�������մMoT�ҥ��c7d����㽤�\=�9N> GG*_}W��!���LAK�lR�{���h����p֎�}_���hb����$�3�O�;a>B�Mb�C 5�� � mp�)��H[2R8^�r�[�l3F[B;Ke�� ���K��`��$F�U%��� �>��A:���-^�Yƕ��U�]y�.v<����۝Q&b[��:42J*߼�ŏJV�<(���#hgV ��ʿ�Xy���W�+_��3���}����툞���R�P���l'���v�U��I��/�kh��@ӛn �~vd�b]FGa-���j`*;��ī�>" }��[d�/�^����O+W����I#0�@j�|�c:��-���s�+g��v琎#� ��o��<]��g�oM�$4{��^�.w|�=z;b�;���pfl+�>�����ڬ����Q٦7*k�RG��+ :A x���J�s x ��՘�q�%�u�C fq�9��Nn����a"*j�htBi��nm�;?����w�UN}��eb�{0�~wL>��ϻ8a�q�l�3�רƂ�q�D�1�2��+�~��2�L~\S6��׎��G��r}tbll�]�#J��^���a�jۉ�V�9̦��ǐ�y��v֊��y�f�;��B�f>]s��G����� �ش�]��erŒ����ә~4�FO5sM��� �o��vC���:yj�F� ^���~Q�8"+��������� x=zr6U���c��k�F"ᕃ��R��!��� ���D�۠�o`���( �Zb7H��p|���W�w~:�$:�od�':�882j��\r�~���cv��[ܬg�I._��'O�g�ȋ�mpVUf�h1G�V�=����Ax7‡�� �2�p�Q�7��~+d"�ߍ� +#c������ �l�HP�-��A3�<�'㰪�KBǸc#z��&Ǘ3�(�L����g̼p2S�<,�ytᅊp� �';�+ຳ�|%V��F�*���G�)`NH��Yh�O ��ڝ������#� 5O�|h9��F���Do41&� _��7X���\rw����EӰ�M~+mL� S�'5v����"FCX ���h 3dߠ"��������#����O+}g���~������ �#�zT]8��QnQ!_��]��� ��x�M��f"f����-��ׯ��y��ݏ�����8j��^�,�{1���/W�{��S)+Y���J�.^[=��Z�j��`�d��+�?_./�Z��F����W�T�� �y�.�`�����tzu�T�������{�}�Fߧ;6�`���S�g��|�{��� ��+ �]{R��Y^���l3��Qm����l~q��u����Ɠfv#�%�3�M�l#@�4�C%��]��=�ğ�U���intY�~2y���}p��V oViC�%Idk��SF�{�C����+�.Ů��y�I"�l��dp��W��;9I�h's3*�1) �e!e�k�{�=J|�*R!�xE����jq,��#����$y7*M .͡�p}���J�4'�c�`�,��'�̓R�ǵ�g�E{-H�>��Q�94��q>�ӎ�v�� h&�yM1Uċ�@y��_� ~�>��v�C\ �E}n�3����U�̙�6�m�0nk��d��S?�l BC���dM��X�dt���xk�#�ҍ^o{GTF��0J��������R�F /�j!��BY�Fw��� ��ɩx*d��(6�|ۃZ/!3Lf��]AH�%{����Uo�v9�=�OS������P�`{�{w���m����4oFA[&*|��Y���o&��D+e�6[?�!�J3���<8�mt`-m^���o�q���]��A����;�+������6Gzs_�, +߶I�깏�%Q�&�1�7�o�cXK��܆ 7��Uuo�'[?�1��Dl�{��d\�0R'ϡ��*�= !ߺ��.c�S�R����;�5�8� M��n�;�;��f���ȓ�$�Wו�m3���h�ea��Ơ[��� ����F���=����yq˧~D����E�D�}�p�m�lKoN\�v�=���ɮE�ؙ,A4�d�ca�͋ބ�.��ʷ='l����I/�C}����8�m�r`-m^�z#�#��M�͉ �&��H��8ؽSu| ����s�|k�������U��U���1�i�(��y��K��k�@�nw�� ����4��6Sz^C�pD'� 2�^Jh�/�"�D�׼���A�k)� vVAv���Zhz����:8������Dx��sI�k�<�ڬ3�$X��d\��Y�Ok��Y�d���y!�� m�������<��Zs�zbH�QC)��� ��j���h2R�phEw��c�(rp�E�Q��0��0|`� ��Bq7> -7��ZQi�Q�L�{����m ���V�4IK�DS��n� BH��evE���z��Z�F�:ꏷIW�?�+ y�]�1m�"�M"�c1��D�� �� �"�6e����!���N:�m�Ɖb(y���~>J� � }C&w ����T��8&b{._���(�Q�'�)v:���bƜG{v9o���F�����C� g�X,&7��}�B0Q�Q�-�U�*E�q��eG�G��C B����6r�‹�£ ���e�!h��ݫEA��d�5Q!Nq��hB�����ag��V�nY�3(���|���2�}�ve�|�������C$;(�*j�B���΂SL2x�����9Q C��7mj�:A��"Ӥ2$�۫��娆�P��oG԰�B���b���&����kV�G�7��ȟn�k�w~�QS�G�% Q�D���B����0g"d���n�Dسn��+�=�Q�����ݺ꽇j���-L����t����ӈZ�F�3����n%��w��w�w�C�"��y�QW�Cl�� ���SnH��?~(S~t��^3�"v�\���e����S�1/�6��o�;ْ� ��eȕ����zP~�B�'e7�2�^R����`�[o�S�� �\�$�\�f�u;Gj�19�ja��KLF��{w��e�ׇ�~}xޝ�Z�g߳�Զ��tNK�@�����}:�~�����A��7W����~y��ԥ࡯3��x���Ɛ��3b���T+��2ۅs��WHcT�� NdD�BtD��S`����ך�F��p���o5N@!��ZX�}nN͗�3��jZ�!�fMG*o.U���T����m"��›�g)X,ffߑ��(�VSh'��b �e�Y��w0C�����:h%FZs�q��-����.��=D#�I3v^�4��(��| q�Kw#��]��?�n��|��MBr)����zw�]���������|� �x��}�߀��'�X��/| �譆=T���isAW}�} �4�$ �+i�̭��#�A8��E�+�����K�oޕ�u�B�̗ɪ�"Lb�H�ɲ�բk�'r�׵ �o��A �� hT��9boK�h�iJQ!�U���?�_ ��v]�۵��X�u����p�h�7��;Qx�����������a����?�M�>�Ѣ��^��nH�����5��~~t��� Y�:Iv�x%��]��# k�PS���"}���=0b����l��0)S�A`jX���goU?~�L�2�K���;��ב�S͉��N-���xS�lT6L1=�jP��ꁩ�� �nP��S��bGf:��n����~� �S|��T��+>��;G�^cŻ/��55�vL� S��Z�v�r��:0ps�����.SnG�L5%bG�)�S��適�ꁩ �\��S�����W�n����o_q�������k���\�L���`j|��)ё�S͈��` z 0ՠ =0�S=0�s�TW�og�C8]�:�9���T��L��̓:���8L�H�v`�?��{��Ԉ@R��gWO]�CR7=^d�rB�x��w��D�;��Ծ�.90�udk���f ;IAI�Z�㆞���TI����ER]5�=$塇�ARH�(��u����h�H +7��CR7=^�R$5�[��DGAL���n=ߗhF��FRPR ��!���!�����j�{H�C����:�#H*��o,�ߘS�O)�x�L��رK���nS�#[ ������`�AAz`��z`j炩�������怩��S�A`j\��Տ��r�J� ��c�����L��l-�jF��S�S��適�ꁩ� ��j�{`�C���ǭ#;S�;���w|�;���}Y��nz�إHj�nAR�#[�������H�AAzH���zHj�"��������� )d��4�J � )��'gW_����5?� ���b�"��݂�DG�I5#bg#)(��'���zH���v.����!)=l���^ŽƖJE=�E�|�TöT�M��L%v ��Z0Ռ�� ���S ��S=0�S;Lu������6Lu*��/1�-�m�<|w��Gu�R7=^�R$�[B�'DG�I5#bg#)()�T����TI����ER]5��BR^�s8t�%��oF��D�ٌ�����F+s������,L� �n�b7�%Rg�T�<`-o����r�#Y5�9t���g̋O��ʵ�ե��?^��T9�a��3<��T7ݶX�"�/;�id��H��Օ�~}������ϒ(�녫b����� (=I$^W��  }9W�ǣ<�o}VC_�̒we�44ɧ $B�"�7m"-x\O"�^�ʒc�u�_B�N�W<&��hO�����1��,`��CN�x+�C�Y�eD��Li�w8�t}Z�Q�6fu�&u����y�]�D�"\� (�KK7�W�c�4��:�Ӵ2^��UIfk9W�����]�Ќcg� ����{�W��"��t Q5�h�Q�e79�v��e�ʋ˿\�^���ͤ�+���߸R����?�&��f4;m�"�t��_~p�|�~�Ï��__�޺X~x�|����U����޽ꍇ�K���~\���埗H�9�Ŀ^�QF6$�R�F ��Q^/������ 5C��-�,d���T���(�����V>������O�ݪK��U�L�j�M*9���E2W�iM*V6�?<4:�$&�|�T��W�*wna������ۑ*�%ԕk�� �r�Ji���VK��Mqo3=!�aZ�;{�dVs�# \5���l{�2S�)�z��w�����Y�U�A����S~T��>_J7�\�=�IV�BP�_���ʭ �� ���k�$-l\2x)P_i+�)��zl���숦�L���dM�G �$W�r!8�]酒Tn|T��/P^|Y~p�� 8�6ɝ`/�CH� ���\��Fe�R���k��ަ�t�,N�Ґ�؈#�+,�{����ײ$7q�-� j1"���t���7�&�����������S���ٻ��4S�6Օ,���.jT ��(��2(���2�o�+_Zl�� >�W��ȤvQ��#{����3_TNܜ��6銲��-�.�s}��W���n�����,iy��ו�~,_��� �)��I��C��ih�v^s�XOW�|�B��o����YY���d!�%cEu��EOT�E| ��VY��F�'�B *�t�����3%���� S�_ᙕ-�5�3�\9�M������:�h�qj�JW.�����r�{�����+ׯ��N ��m���V�}aF�� ^b�r�?&�_�T^��C1;�e�;�z2�6���b����R�jdbՆ> �n��Eb��g�B����g�Ҹ�Yq'W*� ���39��'WH��#3�'e*�A�'�2���AM���F��S�E�8)��X���S��ޕ/��N!���h��g9�U P���3�7�m�P�`��m�H���,�k�p^�A��{��(Ս5�C�K�|�"= �O�5�u��+� �D�����8�� ��9`\ ��j>�L�K����U����ov��Vb��=,�93A�\d| �1��͢ ���=*�56Yd����V�Z3\���ޭ9�I��T"��F���R(6AR�㘅H���iI>B�⳶��*�"w.�u6�8MxJC�������Ŭ����,6G�u�P��^��͛�Bil�).bm=s���$f�Yݲ���Oʮ�*#J��XW˲b4_�5k��<���q@��S�֖�k*!Q��<�wGIy,m`_kx?m��X��Wh���܃M{���@͞#E�8�Z��� ̘�p4��Yg^ŦЂ�`��>ki�☊��9|�iJќ�,-���ZU��y�pD�Ut�V��'X�B��g�6 t�UYPO�-�.�Ϙ۳��9�װ��/hx)�*GՅ�j��`����2�=�8 ����<�� ���%� ����~PF9�eP��h� )��=ϋ�j��N(d�����Y ������뀒27