Notice: Use of undefined constant XSALES_DVD_CATEGORY_ID - assumed 'XSALES_DVD_CATEGORY_ID' in /home/xsalesa/public_html/classes/page_specials.php on line 75
Unknown column 'XSALES_DVD_CATEGORY_ID' in 'where clause'
SQL: SELECT DISTINCT(p.products_id), p.products_image, pd.products_name, p.products_price, p.products_quantity, p.products_date_available, p.products_retail_status, (SELECT specials_new_products_price FROM specials s WHERE s.products_id = p.products_id AND status = 1 AND customers_group_id = 0) as products_special_price FROM products p, products_description pd, products_to_categories p2c WHERE p.products_id = pd.products_id AND p.products_retail_status = 1 AND p.products_id = p2c.products_id AND p.products_id IN (SELECT products_id FROM specials WHERE status = 1 AND customers_group_id = 0) AND p2c.categories_id IN (XSALES_DVD_CATEGORY_ID,4,4,15,15,43,43,327,327,329,329,460,460,501,501,587,587,588,588,591,591,592,592,636,636,841,841,844,844,849,849,940,940,1044,1044,1112,1112,443,443,48,48,333,333,429,429,538,538,577,577,624,624,881,881,952,952,1016,1016,1020,1020,1024,1024,1028,1028,1032,1032,1036,1036,1049,1049,502,502,511,511,513,513,596,596,853,853,968,968,338,338,514,514,554,554,586,586,996,996,1000,1000,1004,1004,1040,1040,1077,1077,976,976,337,337,589,589,980,980,984,984,988,988,992,992,1065,1065,51,51,1053,1053,1073,1073,1108,1108,309,309,661,661,910,910,912,912,915,915,1129,1129,667,667,653,653,672,672,896,896,898,898,899,899,901,901,902,902,903,903,914,914,865,865,867,867,868,868,869,869,905,905,742,742,907,907,408,408,468,468,916,916,1089,1089,1093,1093,409,409,496,496,804,804,842,842,797,797,451,451,883,883,884,884,889,889,890,890,885,885,886,886,887,887,888,888,891,891,453,453,928,928,857,857,929,929,934,934,482,482,517,517,935,935,1128,1128,323,323,455,455,639,639,711,711,924,924,926,926,927,927,933,933,1111,1111,304,304,1107,1107,537,537,1,1,58,58,61,61,68,68,84,84,96,96,99,99,120,120,166,166,396,396,749,749,1120,1120,62,62,65,65,80,80,93,93,8,8,138,138,262,262,94,94,98,98,108,108,134,134,57,57,66,66,67,67,70,70,73,73,104,104,275,275,466,466,136,136,142,142,169,169,276,276,281,281,284,284,351,351,750,750,7,7,326,326,873,873,874,874,875,875,876,876,877,877,69,69,153,153,155,155,795,795,1121,1121,2,2,14,14,179,179,182,182,187,187,190,190,191,191,193,193,199,199,203,203,208,208,212,212,219,219,248,248,258,258,288,288,397,397,398,398,753,753,207,207,213,213,214,214,225,225,260,260,754,754,755,755,783,783,1115,1115,1116,1116,1117,1117,1118,1118,1119,1119,626,626,828,828,944,944,307,307,383,383,384,384,385,385,858,858,917,917,393,393,498,498,644,644,880,880,919,919,948,948,1124,1124,1125,1125,1126,1126,1127,1127,1130,1130) ORDER BY p.products_id DESC LIMIT 0, 96