| Product Name |
Model |
Price |
1054 - Unknown column 'p.products_id' in 'on clause'
SELECT s.specials_new_products_price, p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd LEFT JOIN specials s ON p.products_id=s.products_id WHERE p.products_id = pd.products_id AND p.products_status = 1 AND p.products_id not in (2, 2, 3, 5, 6, 6, 7, 8, 10, 11, 12, 12, 13, 13, 15, 16, 17, 18, 23, 24, 25, 26, 27, 28, 28, 28, 29, 30, 31, 35, 36, 37, 38, 39, 41, 42, 43, 44, 45, 47, 47, 48, 48, 48, 50, 50, 51, 51, 51, 53, 53, 54, 54, 54, 56, 56, 56, 58, 58, 59, 62, 62, 63, 64, 65, 67, 69, 69, 71, 71, 72, 72, 72, 75, 75, 76, 76, 77, 78, 78, 78, 79, 79, 80, 80, 81, 81, 82, 82, 83, 84, 85, 85, 86, 86, 87, 87, 88, 88, 89, 89, 90, 90, 91, 92, 92, 93, 93, 93, 97, 98, 99, 101, 101, 102, 102, 103, 103, 104, 104, 106, 111, 111, 111, 112, 113, 114, 115, 115, 116, 116, 117, 117, 118, 118, 119, 119, 120, 120, 121, 123, 125, 126, 127, 128, 131, 135, 136, 138, 138, 141, 142, 143, 144, 147, 147, 149, 150, 150, 151, 152, 153, 155, 158, 159, 160, 161, 162, 163, 164, 165, 168, 169, 170, 171, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 201, 202, 206, 207, 208, 209, 210, 212, 213, 213, 213, 217, 217, 219, 219, 220, 222, 223, 224, 225, 226, 226, 227, 227, 228, 229, 230, 231, 232, 233, 233, 234, 234, 235, 235, 236, 236, 237, 238, 241, 242, 242, 243, 248, 249, 250, 251, 253, 255, 256, 257, 258, 260, 264, 265, 266, 267, 269, 270, 271, 275, 276, 277, 278, 279, 281, 282, 291, 292, 293, 297, 297, 301, 302, 303, 304, 305, 306, 307, 309, 310, 311, 312, 314, 315, 316, 317, 318, 320, 321, 322, 324, 325, 326, 327, 328, 328, 329, 329, 330, 331, 332, 333, 334, 337, 338, 339, 340, 341, 342, 343, 344, 346, 347, 348, 349, 358, 362, 363, 365, 366, 368, 369, 373, 378, 379, 380, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 420, 422, 424, 428, 432, 433, 435, 436, 437, 438, 441, 444, 445, 446, 447, 448, 449, 450, 450, 451, 458, 465, 468, 470, 470, 474, 474, 476, 477, 483, 486, 489, 489, 493, 510, 511, 512, 512, 524, 525, 527, 528, 529, 531, 532, 533, 534, 535, 540, 543, 544, 545, 546, 548, 549, 550, 551, 552, 553, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 580, 581, 583, 584, 584, 585, 585, 586, 586, 587, 589, 590, 590, 591, 591, 592, 592, 593, 594, 594, 595, 596, 596, 597, 598, 598, 599, 599, 600, 600, 602, 602, 605, 605, 605, 605, 606, 606, 607, 607, 609, 610, 610, 611, 611, 612, 612, 616, 617, 631, 639, 640, 641, 642, 645, 646, 647, 648, 649, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 687, 688, 689, 690, 691, 692, 693, 696, 697, 700, 701, 702, 703, 704, 705, 706, 707, 711, 712, 714, 715, 716, 717, 718, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 739, 740, 741, 742, 743, 754, 756, 765, 769, 770, 772, 774, 776, 777, 778, 779, 780, 781, 782, 784, 785, 786, 787, 788, 789, 790, 791, 792, 795, 796, 797, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 831, 832, 832, 833, 833, 834, 835, 835, 837, 838, 839, 840, 841, 842, 843, 844, 846, 847, 848, 849, 850, 851, 852, 853, 854, 857, 865, 865, 866, 866, 867, 867, 868, 868, 869, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 880, 881, 883, 884, 888, 889, 890, 891, 892, 892, 893, 893, 894, 894, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 922, 925, 926, 927, 929, 930, 931, 932, 933, 934, 935, 937, 937, 937, 940, 941, 942, 943, 944, 945, 946, 947, 948, 948, 949, 950, 950, 950, 951, 952, 953, 954, 955, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1010, 1011, 1012, 1013, 1014, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1066, 1067, 1068, 1069, 1071, 1072, 1073, 1074, 1076, 1077, 1079, 1080, 1081, 1082, 1083, 1084, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 0) AND pd.language_id = 1 ORDER BY pd.products_name
[TEP STOP]
|
