Figura Geyper man Marine U.S.A. en caja expositora grande. Corresponde al equipo completo, nunca antes comercializado junto con una figura.
Contiene los siguientes elementos:
- Figura Geyperman
- Chaqueta y pantalón mimetizados. Excedente de existencias de Geyper, años 70
- Cinturón
- Dos cartucheras
- Colt 45
- Funda para el Colt
- Botas
- Casco M1
- Fusil M16
- Bípolde
- Caja de munición
- Seis granadas de mano
- Tres cartuchos de dinamita
- Prismáticos
- Cantimplora
Edición limitada de coleccionista
MAIN: SELECT DISTINCT popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM products_options popt, products_attributes patrib
WHERE patrib.products_id='1162'
AND patrib.options_id = popt.products_options_id
AND popt.language_id = '3' and popt.products_options_track_stock = '1'
ORDER by popt.products_options_name
SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix
FROM products_attributes pa, products_options_values pov
WHERE pa.products_id = '1162'
AND pa.options_id = '6'
AND pa.options_values_id = pov.products_options_values_id
AND pov.language_id = '3'
SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix
FROM products_attributes pa, products_options_values pov
WHERE pa.products_id = '1162'
AND pa.options_id = '6'
AND pa.options_values_id = pov.products_options_values_id
AND pov.language_id = '3'
Array
(
[0] => Array
(
[oid] => 6
[oname] => Figura
[ovals] => Array
(
[0] => Array
(
[id] => 17
[text] => Primera generación
)
[1] => Array
(
[id] => 18
[text] => Segunda generación
)
)
[default] => 0
)
)
MAIN: SELECT DISTINCT popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM products_options popt, products_attributes patrib
WHERE patrib.products_id='1162'
AND patrib.options_id = popt.products_options_id
AND popt.language_id = '3' and popt.products_options_track_stock = '0'
ORDER by popt.products_options_name
