Autors: Carlos A. Gamissans, Alfonso C. Villar, Núria Burguillos, Ana C. Salazar, Vicente Montemayor, Aleix Clos, Ana Arenaza, Manuel Chapuseaux, Santiago Vázquez, Luz Leira, Rafael Castillo, Benito Pastoriza, Héctor Navarro, Alberto Sousa, Gemma Pellissa, Juan C. Somoza, Rafael Romero, Hernando Castillo, Laura Delgado, Rosa García, Antonio Casas, Ana I. Velasco, Pere Ventura, Teresa Cardona, Carlos Granda, Mattin Eizagirre, Loli González, Francisco M. Marcos, Marta Bordons, Manuel Juárez, Lidia Gregorio, Clarisa Leal, Miguel A. Salamero, Miguel Alayrach i Xavier Osorio.
Opcions disponibles:
Format:
14 - Can't change size of file (Errcode: 28)
SELECT pef.products_extra_fields_order, pef.products_extra_fields_id as id, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM products_extra_fields pef
LEFT JOIN products_to_products_extra_fields ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=46 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='2')
ORDER BY pef.products_extra_fields_order
[TEP STOP]