קטגוריות

בלמים לאופנוע, קטנוע, טרקטורון (2845 מוצרים)

מוצרים 33 ל 48 (מתוך 2845 מוצרים)
1021 - Disk full (/tmp/#sql_6567_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select p.products_image, pd.products_name, p.products_model, p.products_weight, p.products_id, p.manufacturers_id, p.products_price, p.products_max_price, p.products_price_mrkt ,p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where (p.products_status=1 ) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '7' and p2c.categories_id IN( 41,445,694,57,1124,1134,1135,195,252,253,603,856,857,1125,1136,1137,1126,1138,1139,1666,1665,1667,1127,1140,1141,1668,1768,149,257,256,148,255,254,151,261,260,150,259,258,952,953,951,152,262,263,153,265,264,1697,1698,1699,1700,2001,1128,1142,1143,1129,1144,1145,604,858,859,1669,1670,1737,198,267,266,1992,1130,1146,1147,197,269,268,1682,1683,2028,2032,154,271,270,1806,1807,1808,196,272,273,1131,1148,1149,1804,1805,155,275,274,1132,1150,1151,1802,1803,1133,1152,1153,605,860,861,1702,56,588,862,863,589,866,867,1398,1451,1452,1868,1399,1453,1454,1869,141,232,233,1400,1455,1456,1401,1457,1458,1402,1464,1465,1655,1656,1459,1460,1461,1404,1462,1463,142,740,235,234,741,864,865,590,868,869,1405,1466,1467,1892,1403,1468,1469,140,238,239,454,455,456,143,241,240,592,872,873,1674,1673,1672,144,243,242,591,870,871,1815,1816,1817,2033,593,874,875,594,876,877,982,983,984,1987,1857,595,878,879,978,145,245,244,423,418,420,419,453,596,880,881,598,884,885,1679,1680,1681,597,882,883,599,886,887,600,888,889,602,890,891,601,892,893,1809,1810,1811,1406,1470,1471,147,246,247,146,248,249,217,250,251,1812,1813,1814,2008,1407,1472,1473,58,1250,1273,1274,1885,1887,1253,1279,1280,1888,1254,1281,1282,1255,1619,1620,1886,1257,1623,1624,1258,1625,1626,156,276,277,1986,606,894,895,1659,1660,1657,1658,1259,1627,1628,1260,1629,1630,157,278,279,1261,1631,1632,1662,1661,1889,607,896,897,158,280,281,623,624,1704,1820,1821,608,898,899,1663,1664,1262,1614,1615,199,283,282,2018,1263,1633,1634,1264,1578,1579,2025,1265,1635,1636,2019,609,900,901,159,285,286,160,287,288,961,962,963,1890,1266,1637,1638,1818,1819,2009,1267,1639,1640,1875,1891,610,902,903,1269,1643,1644,1270,1645,1646,2006,1271,1647,1648,1272,1649,1650,611,904,905,695,1651,1652,696,1941,1942,1943,1944,1945,1946,1947,1948,1949,2010,1950,1951,1964,1952,1953,1954,1955,1956,1957,697,698,114,612,906,907,1020,1064,1065,1021,1066,1067,161,289,290,1022,1068,1069,1023,1070,1071,1024,1072,1073,613,908,909,614,910,911,846,912,913,1025,1074,1075,1026,1076,1077,162,291,292,615,914,915,937,938,939,200,298,299,163,294,295,616,916,917,617,918,919,201,296,297,618,920,921,1895,2013,1027,1078,1079,995,996,997,619,922,923,620,924,925,202,303,302,164,300,301,955,956,957,954,1080,1084,1085,1081,1082,1083,621,926,927,622,928,929,1028,1086,1087,1860,699,1959,1958,1960,1961,1963,1962,1979,133,700,712,713,701,715,714,702,716,717,703,718,719,704,720,721,705,722,723,706,725,724,707,727,726,708,728,729,709,731,730,710,732,733,711,735,734,2004,738,739,457) order by p.products_sold DESC limit 32, 16

[TEP STOP]