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 March
Dāvanas komplekts uz 1.gadu ( zēnam) - Torte no pamperiem
Dāvanas komplekts uz 1.gadu ( zēnam) - Torte no pamperiem
50 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
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

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]