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��}kwE��g�����8/�g,�r�k$1L�3�Y!98�;���jIm��[t���ZI r�%$� 2 ! �9c]����>����-u�bK��#3uWWW�ڵ����k��}���g�r� )k�s�=���s����'�{�S��:�|8�~ MKxF٥�j$B9�I9Y[H�BR:'�f"�*ӡ��g�y&��� �I3#/�~�����O��ې�"g�{�<����������-��zP�,E�$U� ���*KRA^P�fw!�b�ȡ�ZN��٢� ���yA�Pֲ �����RD��Jشtc9���QU�('"�l�QC/ZJ�e�i+���⼜����G[�l�VN���Լv�F峷��W*?�Yz�l���ӗ~}��T:s�|����_ARi��ڽ{�7��μ]��F��3k�.�?�+�,y�m���b� �`��F�8�<���vK�'/T.�,�:[:�9(�^��8����j��{��7��TN__��F��Ӝ���І6T�~��ͥ��/�n]�~�R]9S=�3ZQ��������ަ<���;�o����|�L囕��ڲ1Ǖ�%�Ș>lu8��j�M�((�����Wo�:�-}�q��m�-�0�y�O�$Lf�4�+Ѵl�9}!���Q�9��[�+,�S��\pU\��%%e���GF�,/��=VPڢ���f�,L��J���گ?�� Y������{���u:+�b%B�>�dx:�FR�D� DA7��0�؎�f7��&��ʹ���sJ"�Si�ڰ�BQ]L��_�����|A���Â��H(�F] �$��nTV/�_�Y��Z>�i�;'+�ވG�so[S��HYC��6*@���q����C�e�H���en�K)�˴iFMk9�Dp� %��{3�(`#IM"d)',��*� ���%�H'BA�{���Q����_^�"�P��������:޶S[J�-�2�B��un6Xa̜�J��%����y�ԝ��m����t�c��iFt}!���d��}t^Ϋ���Ⴂ������F�u::Ez�N��<Ժ�z�H+���1tV�$��Sӣ�b��;�C$�g3ccC����� q���n�Nj��i��/�ˌ��^Wv�\�sV����y���*��G�M�Ŧ�s�e �$~t1�L5�6PWc� n�< ݄�����<�'S�q{R?8���Q�E ���W�5.L˻��1�.* ���u�I}ڥ~uդ/���N�bR�Xf�;�]�V�D/�Q��b�� �(fy]�!OK�a MW1��h^a)�BNƿJN&#-����lXRôE�e�`�U�P#i.�bDm1tn�:Q�125㭆�M�s ����nBhў��C�ɒS����&Z�Q��m�DM��m�l�@h�\�� ��JH��n�%^��: �Z��2�z�T��Mp�lZ���6�M�.,J� ]7„�3>��a���V*�t�MF &�l�W1yj��x���v��1��qU�\��u�����o`���Z�VQ��QsT]5F����K�sC����c��[�Դy8uLI[C�'��s�� ��嗝�G^b�Qj��0���/?��H�P4�ò�P�c��ye���%b�հ��8���r 5�<���Y���(��ǃ������h�ϟ{����e-��ኤr�@>R� �Q"�fb�� �L��Q��� /aIL_��iF�����(�7 t|.��ƳI�� ��ȁ����!N�Ш4�)��dljbfj2��h�,/�ib ��i��&��gV��,�u��$�sz�/�i��H�D_I�l�f���J��‰�����@N7f���'�����Qߜv���I��2� ��<+a>�> g2���f '��DYyȏ��S�(<+��{1��:g�� :֖ �X�XT��b�Zb ;�f<��h�d\3Ɏ�J�Vi�X�h������jZ������RN+��ǥ#� ���3J�Uo����:ΏJ�QI�G%mT�F%sDz�C�-!X���̧^�}L� k�Zc��&%$�:���$�.�w.wH��zFz4�N�U'[D.r��hH͎H����KQ��0�E��O=5~�|d�i��s�/���f�s��Q2ȱ7@��Ȣb��L��� ��+Z�L�=��³T�)UF�r�ل,��*�/�`��|ͳ�̳oW����i�;���� ��c�%LjKC��5Fd �V_9�VE4Ŋ*�ܳG��)e�$ �0� EC ��h9�,ulbjzff*�79511���^ Z�4�����s4O���0�C /�T3�J�8U}F��� �y�-���.F���_���t" I|�����I�l�����0�g3�D���_Q�xT�$�򈲘��}�&K��EG1�7X0�}����Ӈ��~��'��`�@�Ep7�X�����<����yvB����)=�l�_���n�ʹ�Or�q)��[a����xF]���P~���Q4y�� j�{/ݵ�� �З�����s��� 3��0@�̋�|��� ��ԑ�'.CnhX�2�9�c����y�r!kց�X�o�")��zQ��k��aVL�+$v��D�,q�Ҽ�2��z��� � Z����)*_��1�MV޻_:s#���d̋��>��)����a5��'NXA�WW��D���O�Fz�EH��7���� �l(@���F�I*���v#���]� �]�c j0lʆa���� �Z�-nAIYZx��J�`�T�L�Y�<�cK�|���–��U��DԈ�"�4���{M���s9#��F̽� ��O�T�!)�c�O �2��QҺ�G������JF-�E�������3yd"�%l>'/���q>��s��W����������15�/���Ѥ���9�'�my��Z�h� nV�@�C�+9>C��E9WD�b��$��F�W��8�:��+�G��vm1vvQW3�c#�5K�tS���$ ���r-������P�K�+�/ˈ^�9\�AIŜ-�y� �T]`��hd�}d������Jʾ=f�,�,����܂8T����Gsjҩ����+|"����[( � �/���l"69 ��\���U-���$ҽ�5�u��I���.���g�o�m����%y6��"v%�7[�X!1-�a+�6"���193��qT���ţ�THJ�~�~��륳��_�u�]M����Oam%u�{!��E��+����ϱ#j<����� ��\l\���Z9_��sl*�M]�~��� ��X=�]�����i�ٿ�.��2�zd�Р�IjP��m/���r�~��վ��Y1�+��c�����~W��1��v��~3b���=kK�]�-�β����N�M�W�ۋ$a�vٗ��� M�%t�ەn�u����d�n���쎂�zG��0��o����z��'k?](_=s�6�z`�����o��-Ƨ򙳥+���H��[��㷥�*}�3��G, �oSx�T?����g���^��~�ք��k����nC��Z���L|޻W>�Y�I� - K�c�`��q"k\g�u�1 ��S4>?��FW� .��l�x&�HG�%Ő�K��i�� Hg3��YY��!/*��"��?�-�S � �{�g��~h�8��O5I�OΆ��[f?csȣ�=���EMՍ�P�o��3z�2�T�҃���y`�G�:> ��������¸���_��.ɚOs[Jy�>�)����thO&c����43�4����9X��7�R�x��޽��w�W/!����ŮL��ޖp񏴮�|/�/ ��$Kg��'�s�”.��|� ����})�M���+��Wp��@�u���HϺ��sjln K!>��uDm�Շ��Mh�Ч����ҍ�\0�i R�?�xR�J���eQ�I�*Lkw/"D��'�6��[���5=�t6��0�~\z�Z���.H4{'4l��c�����E������w�f�� q3�  ��U�,P��� ��]1��mǔe�g|��ZU}�>����Oam%u�{��34�g_Py��[����Y���W[b[�c� �����ogJ$"����F'�7��uw��sf��������oQ��X��'������ /v�:a���EPY[��(Y�� ]�w~I�ͯmf��ɻ+nb}m�+�p��.ׇg��&P*�;��o�v�o k�ID1�ǵ`>6U�|�}���Z�WI�_4�2��4��Z� �r�#G�����(D5�����?,?�F���j�V3�5z.�z��>�8����������it�9X�-�"����ыٹ?�)jf������<�`~_ DΚ�M ��ʰ�����>f�������+p��= A�c�4ۅgyg�t .K��e�=:;81>y��(�o�xE�� �, {��nSCr� �P�\LgfG���\�`���u`���9�$w-�L7����̓���O�$���+�]�,���B����{�S���y�g#�bf���#�+3o_�3���'ƥ�����'�����7s$���Ѡh�JV��qHV;%�k�1���u���fA���1f� \���$�V'?/|P�"Aud�|l��O�ĺ%��������0�$�w,4y-�<��N��FzC8qυ��K3χ|C@�`Q'��plJG�0 ��B��I�/����]3�M�+�� c�#5~����Et�0�'��,ϑ�����`^5�r�,}}�.��}Z��;k��p��U^�o��3��>Ҡ�G��#r����M,3�o^gP�(Ǜl4��0��1sfVenm���~�z�A��������p�*��X^�cJ?�^?��bV���Ȕ�,ys��r��\[?��Znj��`���啵�/�Vo��q����WO��� �y��c�����zj}�d��ҽյ��~�Dϯ�7����/S1�� �\�k�VF �[���zߞbl*�@ 77S�aHX������W�lø{Xb�I� {��X � M��F���Cd%��=��>�؟��Dz"��6K�_$#�[�������A��� m������Q�N���贊�K��1�5W��u6Ɇ2�A�-]���\�('�s32 >),�;�BJ�!��{���BNQ�&B6|�kl�����@%=�ظ�� ���(5��4����� ,�"<+��X��(������(2����1��zi����V� ��Fk�}+�{ZS�Iy~=��?��)�����+���72F{nmܳ�MS'���oS�;� �e��z�9s?Q�q֭u߻̟��'�І�id�jIC��(7<�I�����*t�������nF�b�" �h�&�&����§�ֱ�B���׼j��d��d<� .7˟ͼ�q��K����嵞؎;����ܓ�� � ��R,I��`����� ���p|X;fɆ|^�a�ftd����U��3�rR;o���c��c�]i�Z;�|����-���`ѹ#�ֻw�)Z�nH�]�{�ܧ\���+��92�:eYP��M�v�}/�G���, �;����o}K�0q�m�p��Q�U7�y��c�D� ��8��%�����S�P���P��K��N�3��� �w��K֐� 74��:��#w$ ���ȓ�$�Yד�3d0��eA�;Ơ�=��( ���� �o�vܹ��t���C?�@԰���E��6m:�a ���&�D� ��AԊd�bV�'K#��h�b0�wʲ��� �>�#~F� �P-c0��vtǽ�[J���o�yl�H�5�A:�\�6 {�+��ς!u� ��[CAM\�q�6uv�Is:~�r[e˭)�������� �v6��K$���[����qyj�`�tc?!��8-�� �����e|���1vl̻zT�I�}� �` �7�z|��$qG�c �C{�I�} ��/[6�����=B����f�������O'm��a��[�S^�V!�R���:��`͢S����Y����p,*?ζ��}^��E��Q{%Nn����l���[���4{p���e���;f��[n.íg�Z���0� R�6�iz!�SjN�a�ZbZ{��"���&N� 3_z�c� =�ӯ]�^������ ��B�;�ż���7�<�̀'¯ض�8A��#��[�R��`'��9u����R r=f�|�Y�� B��O�E�I~{�b#�%��D$�i�;+�S��|�̸���\��-w��tFbQg$'R�7P �Y�˼�p��6�w���U��[[@�V�)dK���2N3A�MU�y���, ����艧�Uh��@��b�y��8��V�T)��,�>�loQ��X�p7��/"�SF9�C��nPG �A�(�� �҇)�aA�+�Na�������#��rq��MH�Ȗ��?4�&BC/d�%�lϒs��Q��0U�U p� �O�H�]�HEX>QF�J�UnA��u�VĦɖ� %��F$�����6��� ������f�!�� �ͫ�Gt�d��NQ"Nq��hC�Ǽ��m����f\ ��*�>��?_©`߽]^=Wz�5���� j5��|ܴ��8� �?be�"nN��ӽ�����P��4+�������nX�f5d�q��M�>�+���c�ñ�1W�5��t����[ ܿv{�i�5֨�>��.��Hti�G�j��H�x�3���H;�"��Y7R� ��i�i�+Z�� 2�u�;/�78����~]3[ҥ���N#�)*�Ƞ*^�څH""B�޹��ى��ە�*`C^P�E`PwEB���E��q<ְ��#���gk�C.��;e�Ƽ ��SA�$�%��CY@�W �W�y�����7�n�fDä �����ַ_m3n4�(4HwY.Q��4���YR��ɹS @�;19��N��%��g�~}p��ڔgϻ.����鬒>�C 7�^���}���+����oVo���v9���$���3�v���X��;b e��Rd#� 3ۅ���.�2*�]!6j��|xB2�[`���D�mMT�P�8�b�<��"��|-,e��(犸 I���V����P�����;&��/�8� *�*r D#�g����0�VSh'��l �e�y���0C �����:h%zZy�q�v�c��$~KP�A4��4b�d`O��r�ʇ���4$9����i�Ye,��)���vt �d57t`�{2��8*"��؀�漺��J�؊yY+"2�U4h���>+��h��VB7{X��L������ 3�bK�P�}v���R.�1y��0�%�V�r��?)�Wo C�I m�E�ä�p��N`�%=�?��t��O���,u]b_0��P�-e1��Q�i�7��!�݃��UA��� ԁK����B���Lݑ ;�ڻK1��}UK����.��ܜZ,:�T� ѥiI��0�{@%��?7vV��b�)b� ������升�𸄆�)��9(��4>h�~u<�Qpo qQ컓a�������ؾXl|,6���Xxj���X�@f���=�8�7n���ʛ�p�3>�?���3Y��M����&�o|:e.�c"=g���������(��%&��P����S}��_��95}�/D�wx04�,�"Z������� �y0m6� �ϳ0a�z�Rq|�=/a�ʵRfV�g� � ��6BE����7�]T���!�E�C}���5�\�5-l��z#�C����f�� |€J� ��!v�T ����+�O%�{�o��#cޤ�;���~\�v���e7}<ײ�]y_��7^�n��O tP{�a��T�(�j�R1��"�h��Aͽ��o)'�6GֽN��E^���)�����5$�T�~$~ŏ8�έ�4`���Wm��0)�DS�~hj\���goU>�\��| !ݥh �;ДӐ�DS͉��Nm���8c�۪l%�b� 4ՠ 45@S4�I4ݠ�[����v�t}2݆�� �6į���H![x�w��h1��C`�C�������}M�_�]��j��y���Tlf��)�!ۊ����h�h�AAhj��h�oєm�hJ ��w�i��u�}��CD�����~hj��������ԡ)���MM�4%��h������@S 2@S45@S���zj�kSz�+/��ȶ�kS]�7u�/s�����Ea�'µMS�q��k��&�*_=�~�|��y�0c!�>m=�d�^h$qC�~�4�/�K6M9 �^(%��KDC)h)S+���ў�@���_(�S�?�Rz�(�c�hd㛦�Pj2JM (���_�A)��3v)���-�R�!�(�n�~����5#����P�AAPj�P��TO��J9�ak�����������7%�T��_J?ިCS>~�R45�[Дh����fD�7���M5(�M ��M�/����)=l ���C45퇦��Z��Տ�ԡ)��?v)�ڿ[Дh����fD�7���M5(�M ��M�/����)=l ��1o�Y�r� ��7c��~��uP��Ì] ���(%��P�� ����R 2�R(5�R� �zj�P�A[�pj^סTl,J��>��ڗ��׼P��Ì] ��w � �^(Ռ���R��C�7*�J ��J�/���@)=l ����x�ݍ1��D�|�d�”�C��M�v � �^4Ռ��FSPT���������ES=5�4堇�AS]����Z���7�\�^��na��Ì] �vK��h��B�fD�7���J5(�J ��J�/�����r�{�{\G�͉�3qm��:G!z��USM�9�Z��U�'�\�Mv�"?�v��8͏�������C��#q#����l,Y�v��zg�����OPy�4?�1�C�.�=^�A̖�k I��t�j���_����x�'?��OLt�넭b����MwF���P� �]'���B�������|��=Y�4`v��APFLC�|���hXDCl��U���I�ֻ#���2���!z'�,���U0g�ѥ�����tc9�������uv:���tDb qr�R����yU����M����%ѡ�.p���]ĥ�3��8�:ɏle�"��T����_u�� N���_����\:o�����3:c�K�yh��r q�����d<;n+ ; \*�<(�r�r�"�p&�X�P^���ƕ�O_�W�5�/0��iCg�Awx���7J��>������� ��J�ί�]��o��ޭ|��t�V���O~^�y�$��K��:�ȆD�1��n(t�s��"0�M%$� t�,@�����ML�>��{���'��/} �m\\5��*���%��IqJ�8�¬������b3ӣ��T������7�^\Zy�9� ���.}N�4:��u�7�UR�~<@S��LOHm��d�G�8�X��5z���=�U�Qs26Z�-���z������_��y��U��f���|]���ҥ�z[�}�1�>���ujʒ�S,@=���+�ڪd�u�G?=V7��,�d� /�1� ���/A4�,kv�D�āWh�B���Vs��#��:j�P�Uxfe�f �L$�'���p����Pg7Z�qD�Z����S�����}����]�~uzxf��޵��^�~�&b� x��L��;������� O�b8��p(�6��������q�� �x�!f����Ͽ��~7=1.ML���?95�;���E������+��ʷ�e�e��c<��y���D(�� Yk666�0�5�Hq�q�v箧�)i�d�mII�dKMGm�٣QU,���#G�pB�>��Ca'�'ف���_+zFVV�H~�$��8�_ѡ��b!�˙�~l~Z��d�D:�� ��tac�� Y�D� }���V�!d6����>��"vw,��*bʧ�{�{�a���Gg�ƅ��� ��7*�iNǰI������P����Oy.]c�^ը�|2�Ft�  ��~vv! ́d1Q:(�r�,��m�v>aJ����Wy �:��N7g&ȗ�l���A���^dtT�c@���"�|:|1���ך%���u-<���BD��0�4��E��nYz~RAb%t�%��`�Y[k�E�I�=�2e�<��UBm���bc�M@Vy~��X��:��F��q�� |�4 �t�����9Oi#��j�P���� e[�ʈ� :6T�[1��ʚUm�J���8��Q����-��(�B�����$=�� ���5���j,��+�G,r���=�R$�@��pA�ʆ%��3�I��g�Z���� -�E��� E�,]2������"�%�P2RjY�5��X�5kTB�XI�LiA�� �,AH�N����j�"��q�%�y2�]ck6�=Gr y����tD^>"� �K�=Q c����0I�m�3Y%�Hi,PRm���*9�e�CJ%�F�xdL�E�%�%O9Pb�x\"S����2� +�K�D�F�o7