I miei prodotti Preferiti
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`='it' LEFT JOIN geoborders.tb_db_price_list_resellers as PRICEEND ON P.product_id=PRICEEND.product_id AND PRICEEND.reseller_directory_id=1 AND PRICEEND.date_start_validity<='2023-09-23' AND (PRICEEND.date_end_validity>='2023-09-23' OR PRICEEND.date_end_validity IS NULL) WHERE 1=1 AND P.product_id in (516, 957, 907, 64, 955, 1010, 978) LIMIT 100
Help Online

Tipo di messaggio:

Inserisci il tuo nome:

Email:

Scrivi qui il tuo messaggio:

Copiare il codice:

INVIA


GEOBORDERS Satellite Ltd - 1B Labton Road, SW20 0LW London, UK - VAT number: GB 984488553
Filiali Italiane: Geoborders Italy SRL PI IT01604480994 - Geoborders Enterprise Solutions SRL PI IT01297760991