Categories
View All Products
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Consultant
  +371 22112773

giftservis@gmail.com

Articles
New Articles

All Articles

 (5)

Mazuļiem
Mazuļiem		 Pirmsskolas
Pirmsskolas		 Pirmklasnieks
Pirmklasnieks
Tinejdzheram
Tinejdzheram
New Products For May
Dāvanas komplekts uz 1.gadu ( zēnam) - Torte no pamperiem
Dāvanas komplekts uz 1.gadu ( zēnam) - Torte no pamperiem
50 EUR		 Saulesbrilles ar aizmugures ainas funkciju
Saulesbrilles ar aizmugures ainas funkciju
21 EUR		 Flash Drive 8GB USB - Antique Cross
Flash Drive 8GB USB - Antique Cross
36 EUR
Mobilais telefons - Dual Sim JINCEN JCE2
Mobilais telefons - Dual Sim JINCEN JCE2
85 EUR		 Parasts telefons ar balss izmaiņu funkciju
Parasts telefons ar balss izmaiņu funkciju
21 EUR		 Rokas pulksteņi ar iebūvēto videokameru
Rokas pulksteņi ar iebūvēto videokameru
85 EUR

Dāvanas bērniem

 Dāvanas bērniem
Dāvanas bērniem
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 21' at line 1

select distinct p.products_image, pd.products_name, 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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c using(categories_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '6' and p2c.categories_id = '36' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0 order by limit 0, 21

[TEP STOP]