Categories
View All Products
Filter
###FILTER_BOX_CONTENT###
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
more
The Shaktipat Empowerment by Baba Prajna Shiva Kalidasa
The Shaktipat Empowerment by Baba Prajna Shiva Kalidasa
108.00 USD
Latest FAQs
RSS 2.0
How To Buy


All Products

All Products
0-9 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
   | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |  Full
1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like'

SELECT min(IF(s.specials_new_products_price is not null, s.specials_new_products_price, IF(pg.customers_group_price is Not null, pg.customers_group_price, pl.products_price))) as minPrice, max(IF(s.specials_new_products_price is not null, s.specials_new_products_price, IF(pg.customers_group_price is Not null, pg.customers_group_price, pl.products_price))) as maxPrice FROM (select distinct p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, p.products_date_added, m.manufacturers_id, m.manufacturers_name, p.products_quantity from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join categories c on c.categories_id = p2c.categories_id and pd.language_id = '1' where pd.products_name like '%' AND p.products_status='1' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 order by pd.products_name, pd.products_id) pl LEFT OUTER JOIN specials s ON pl.products_id = s.products_id and s.customers_group_id = 0 and s.status = 1 LEFT OUTER JOIN products_groups pg ON pl.products_id = pg.products_id and pg.customers_group_id = 0

[TEP STOP]