WHERE povt.productID IN ('2905','2906','2908','2907','1806','2897','2898','2904','2899','2903','2512','2909','2910','2768','2023','3132','2762','2763','2245','2755','2757','2760','2761','2756','2758','2759','1802','1036','1515','1903','915','1867','2984','2591','2248','3100','2251','2259','3119','2239','2766','3095','2131','13017','2605','1804','1514','1905','914','1868','2986','2585','2249','3118','2895','2253','2260','1454','3120','2240','2243','920','13018','3277','1805','2457','1904','913','2985','13124','2250','3101','2252','1455','3121','2264','2242','2244','2618','1516','1906','912','2589','3117','2254','1456','3123','2265','2241','2764','1381','1517','1907','911','1468','2590','2261','3124','2246','2615','2458','1908','1761','13127','2262','2247','2612','2459','916','1469','2593','2263','2765','13128','1520','3096','3131','13129','1518','3098','3133','2621','1521','3099','3134','2625','1522','2624','2611','2610') ORDER BY pot.sort_order, _name_sort
FROM SC_product_options_values as povt LEFT JOIN SC_product_options as pot ON pot.optionID=povt.optionID
SELECT pot.*, IF(LENGTH(pot.name_ru), pot.name_ru, pot.name_ru) AS _name_sort, povt.*
Got error 28 from storage engine
Комментариев нет:
Отправить комментарий