SELECT  '48' as shop_id, products_prices.valentine_price AS valentine_price, products_prices.valentine_price_deluxe AS valentine_price_deluxe, products_prices.valentine_price_premium AS valentine_price_premium, products_prices.categories as product_categories, 
		products_prices.special1_price AS special1_price, products_prices.special1_price_deluxe AS special1_price_deluxe, products_prices.special1_price_premium AS special1_price_premium, 
		products_prices.special2_price AS special2_price, products_prices.special2_price_deluxe AS special2_price_deluxe, products_prices.special2_price_premium AS special2_price_premium, 
		products_prices.special3_price AS special3_price, products_prices.special3_price_deluxe AS special3_price_deluxe, products_prices.special3_price_premium AS special3_price_premium, 
		products_prices.addon_category AS addon_category, products_prices.min_order_qty AS min_order_qty, products_prices.image_type AS image_type, products.id as products_id,  products.fk_shop_id as fk_shop_id,products_prices.options as options, products_prices.aggregate as aggregate, art_nr, image, products_prices.price as products_price, products_prices.price_deluxe as products_price_deluxe, products_prices.price_premium as products_price_premium, products.date_created, status, products_description_sl.title AS title, products_description_sl.title_long AS title_long, products_description_sl.intro AS intro, products_description_sl.intro_deluxe AS intro_deluxe, products_description_sl.intro_premium AS intro_premium, products_description_sl.desc AS description,products_description_sl.desc_long AS description_long, products_description_sl.url AS url
		FROM ((products
		INNER JOIN products_description_sl ON products.id=products_description_sl.product_id AND products_description_sl.shop_id = '48')
		INNER JOIN products_prices ON products.id=products_prices.product_id AND products_prices.shop_id = '48')
		WHERE products.online AND products_prices.online AND products.id ='2040'