Jump to content
Lausli

SQL Export Produkte zischen Menge 1 und 0

Recommended Posts

Guten Tag ihr,

 

ich steh auf dem Schlauch.Ich möchte einen export machen von Artikel deren Bestand zwischen 0 und 1 liegen.

 

Der Code für 0 ist ja der:

SELECT
								a.`id_product`, b.`name` AS `name`, `reference`, a.`price` AS `price`, sa.`active` AS `active`
			, shop.`name` AS `shopname`, a.`id_shop_default`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`, (select count(*) from `ps_statistics_wallposts` pstwitterpost_swp where pstwitterpost_swp.id_product = a.id_product and b.`id_shop` = pstwitterpost_swp.id_shop) as count_wallposts
			FROM `ps_product` a 
			LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
			
		LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
		 AND sav.id_shop = 1  AND sav.id_shop_group = 0 )  JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
				LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
				LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
				LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
				LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`)
				LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) 
			 WHERE 1   AND sav.`quantity` = 0 
			 
			 ORDER BY a.`id_product` ASC

Bekomme aber das "und 1" irgendwie nicht hin, sollte doch so sein:

 

Also ja eig. "AND 1" oder?

Share this post


Link to post
Share on other sites

WHERE sav.`quantity` BETWEEN 0 AND 1

 

 

oder auch

 

 

WHERE sav.`quantity` >= 0 AND sav.`quantity` <=1

 

Grüsse

Whiley

  • Like 1

Share this post


Link to post
Share on other sites

Ah, danke Whiley.

 

Wünsch euch nen guten morgen und Start in den Tag ;) bis denn :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More