Cookies

Errore SQL2: Got error 28 from storage engine SELECT distinct P.product_id,P.short_name,P.video,P.id_immagine,P.part_number,P.weight_kg,concat(PRICEEND.price,' ',PRICEEND.currency) as ENDPRICE,PRICEEND.price as priceend ,PRICEEND.currency as CURRENCY ,FAMILY.description as family,NET.description as network,NET.url_logo as network_logo,MAN.url_logo as man_logo,CONTYPE.description as contype,product_compatible_land ,product_compatible_mobile, product_compatible_marine, product_compatible_aero, product_voice, product_data, product_fax, product_sms ,product_email, PROTYPE.description as protype,PROUSAGE.description as prousage,LIFE.description as life, product_bestseller,MAN.description as man,MAN.website as man_link,FIEL.description as profield,P.bundle_of_product_id,product_new,product_connection_type_id ,P.short_description as short_description2 ,PTR.short_description,COALESCE(product_length_cm,'--') as product_length_cm ,COALESCE( product_width_cm,'--') as product_width_cm, COALESCE(product_height_cm,'--') as product_height_cm ,PTR.description,P.description as description2,product_weight_gr ,product_talk_battery_duration_min,product_standby_battery_duration_min ,PTR.description_of_package,P.description_of_package as description_of_package2,manufactor_part_number ,PTR.description_features,P.description_features as description_features2 ,PTR.descriptions_specifications as description_specifications,P.description_specifications as description_specifications2 FROM geoborders.tb_db_products as P LEFT JOIN geoborders.tb_des_product_family as FAMILY ON P.product_family_id=FAMILY.product_family_id LEFT JOIN geoborders.tb_des_network as NET ON P.product_network_id=NET.network_id LEFT JOIN geoborders.tb_des_connection_type as CONTYPE ON P.product_connection_type_id=CONTYPE.connection_type_id LEFT JOIN geoborders.tb_des_product_type as PROTYPE ON P.product_type_id=PROTYPE.product_type_id LEFT JOIN geoborders.tb_des_product_usage as PROUSAGE ON P.product_usage_id=PROUSAGE.product_usage_id LEFT JOIN geoborders.tb_des_product_life as LIFE ON P.product_life_id=LIFE.product_life_id LEFT JOIN geoborders.tb_des_manufactor as MAN ON P.manufactor_id=MAN.manufactor_id LEFT JOIN geoborders.tb_des_product_field as FIEL ON P.product_field_id=FIEL.product_field_id LEFT JOIN geoborders.`tb_db_products_translations` as PTR ON PTR.product_id=P.product_id and PTR.`language`='en' LEFT JOIN geoborders.tb_db_price_list_sell as PRICEEND ON P.product_id=PRICEEND.product_id AND PRICEEND.company_type_id=1 AND PRICEEND.date_start_validity<='2020-05-30' AND (PRICEEND.date_end_validity>='2020-05-30' OR PRICEEND.date_end_validity IS NULL) WHERE 1=1 AND P.product_id in (979, 980, 642, 982, 168, 171, 167, 170, 169, 721, 620, 877, 876, 875, 878) LIMIT 100