Svět kadeřnictví
Položek v košíku:   
Celková cena:   
Měna:  CZK CZK   EUR EUR   
 Přejít do košíku

Svět kadeřnictví

Profesionální kadeřnické potřeby ...

Pedikúra - Manikúra


 
 1  2  3  4  5 ...  [Další >>] 
Řadit dle:   Název ↑ ↓   Cena ↑ ↓   
 

0 -

select p.products_image, pd.products_description, p.products_weight, p.present_product_min_price, pd.products_name, m.manufacturers_name, p.products_ordered, p.rating, IF(p.products_quantity > 0, 1, IF(p.products_days_deliver = 0, -99, IF(p.products_days_deliver < 5,0,-1) ) ) as skladem, IF(p.products_date_added > DATE_SUB(NOW(),INTERVAL 30 DAY),1,0) as je_novinka, IF(s.expires_date > NOW(), s.expires_date, NULL) as expires_date, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_quantity, p.products_days_deliver, p.products_date_added, p.products_date_available from (products_description pd, products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id) left join specials s on (p.products_id = s.products_id), products_to_categories p2c) left join categories c on (c.categories_id = p2c.categories_id) where c.categories_status = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '7' and p2c.categories_id IN ( SELECT `categories_id` FROM `categories` WHERE `categories_id` = 177 UNION SELECT `categories_id` FROM `categories` WHERE `parent_id` = 177 UNION SELECT c.`categories_id` FROM `categories` as c, `categories` as c2 WHERE c.parent_id=c2.categories_id and c2.parent_id = 177 UNION SELECT c.`categories_id` FROM `categories` as c, `categories` as c2, `categories` as c3 WHERE c.parent_id=c2.categories_id and c2.parent_id=c3.categories_id and c3.parent_id = 177 UNION SELECT c.`categories_id` FROM `categories` as c, `categories` as c2, `categories` as c3, `categories` as c4 WHERE c.parent_id=c2.categories_id and c2.parent_id=c3.categories_id and c3.parent_id=c4.categories_id and c4.parent_id = 177 ) group by p.products_id order by pd.products_name limit 0, 20

[TEP STOP]