Error opening database: istore_v4l:
: Error opening database: istore_v4l:
: Error performing query: SELECT config_name, config_value FROM kid_settings:
: Error closing connection:
: Error performing query: SELECT cy.curr_name,cy.curr_code as currency_code,cy.updated_rate,cs.currency_symbol FROM kid_currency_update as cy INNER JOIN kid_currencies as cs ON cs.currency_code=cy.curr_code WHERE cs.currency_code = 'Pnd' LIMIT 0,1:
: Error performing query: SELECT cy.curr_name,cy.curr_code as currency_code,cy.updated_rate,cs.currency_symbol FROM kid_currency_update as cy INNER JOIN kid_currencies as cs ON cs.currency_code=cy.curr_code WHERE cs.currency_code = 'INR' LIMIT 0,1:
: Error opening database: istore_v4l:
: Error closing connection:
: Error opening database: istore_v4l:
: Error performing query: SELECT config_name, config_value FROM kid_settings:
: Error closing connection:
: Error performing query: SELECT pc.product_id AS pro_count FROM kid_products_categories AS pc LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) LEFT OUTER JOIN kid_products as pro ON ( pro.id = pc.product_id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 AND IF((pro.use_stock = 1), pro.stock > 0,pro.stock =0 ) GROUP BY pc.product_id :
: Error performing query: SELECT DISTINCT pc.product_id,pc.category_id,c.level,pro.main_category,c.parent_id, IF((pro.use_stock = 1), pro.stock,'use') as stock, IF(IF(ROUND(pro.discount_price, 2) != 0 && pro.show_savings !=0 , pro.discount_price, 0) > 0, IF(ROUND(pro.discount_price, 2) != 0 && pro.show_savings !=0 , pro.discount_price, 0) ,pro.original_price) as new_price, pro.name AS product_name, pro_img.image_name AS product_image, pro.original_price AS original_price, IF(ROUND(pro.discount_price, 2) != 0 && pro.show_savings !=0 , pro.discount_price, 0) AS discount_price, IF( (pro.discount_price = 0 && pro.show_savings =1) || (pro.discount_price = 0 && pro.show_savings = 0), 0, pro.show_savings) AS show_savings, if(show_savings !=0, (pro.original_price-pro.discount_price), 0) AS actualDiscountPriceDiff, if(ROUND(pro.discount_price, 2) != 0 && show_savings !=0,((pro.original_price-pro.discount_price)/pro.original_price) *100,0) AS percentage, pro.created_datetime, c.category, IF(LENGTH(pro.description) > 500, CONCAT_WS('', LEFT(pro.description,450),'....'), pro.description) AS description, AVG(rev.rating) AS avg_rating, COUNT(rev.id) AS rating_count, pro.use_stock, pro_att.product_id as att_product FROM kid_products_categories AS pc LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) LEFT OUTER JOIN kid_products as pro ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_products_images AS pro_img ON ((SELECT id AS image_id FROM kid_products_images as img WHERE img.product_id = pro.id AND img.special_image = 0 ORDER BY img.id ASC LIMIT 1 ) = pro_img.id) LEFT OUTER JOIN kid_customer_reviews AS rev ON (rev.product_id = pc.product_id) LEFT OUTER JOIN kid_product_attributes as pro_att ON( pro.id = pro_att.product_id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 AND IF((pro.use_stock = 1), pro.stock > 0,pro.stock =0) GROUP BY pc.product_id ORDER BY new_price ASC LIMIT 0, 12 :
: Error performing query: SELECT config_name, config_value FROM kid_settings WHERE config_name LIKE '' :
: Kid iStore - An E-Commerce Solution with Online Order Processing
    Error performing query: SELECT * FROM kid_categories WHERE parent_id >= '' ORDER BY sort_order, group_id, tree_id ASC :
    :
  • Kid iStore | 
    • Error performing query: SELECT GROUP_CONCAT(CAST(id AS CHAR) SEPARATOR ',') FROM kid_age_categories WHERE status = 1 GROUP BY age_category HAVING age_category='Infant Zone':
    : Error performing query: SELECT GROUP_CONCAT(CAST(id AS CHAR) SEPARATOR ',') FROM kid_age_categories WHERE status = 1 GROUP BY age_category HAVING age_category='Toddler Zone':
    : Error performing query: SELECT GROUP_CONCAT(CAST(id AS CHAR) SEPARATOR ',') FROM kid_age_categories WHERE status = 1 GROUP BY age_category HAVING age_category='Kids Zone':
    : Error performing query: SELECT GROUP_CONCAT(CAST(id AS CHAR) SEPARATOR ',') FROM kid_age_categories WHERE status = 1 GROUP BY age_category HAVING age_category='Hobby Grade':
    :
Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count, gender FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 GROUP BY gender:
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count, character_theme FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 GROUP BY character_theme:
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count, age.id FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) LEFT OUTER JOIN kid_age_categories AS age ON (FIND_IN_SET(age.id, pro.age_category)) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND 1 AND pro.status = 1 AND pro.rental_product = 0 GROUP BY age.id:
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count, brand FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 GROUP BY brand:
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count, pc.category_id FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 GROUP BY pc.category_id:
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=0 AND pro.discount_price <=250 ) OR ( pro.original_price >=0 AND pro.original_price <= 250 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=251 AND pro.discount_price <=500 ) OR ( pro.original_price >=251 AND pro.original_price <= 500 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=501 AND pro.discount_price <=1000 ) OR ( pro.original_price >=501 AND pro.original_price <= 1000 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=1001 AND pro.discount_price <=3000 ) OR ( pro.original_price >=1001 AND pro.original_price <= 3000 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=3001 AND pro.discount_price <=5000 ) OR ( pro.original_price >=3001 AND pro.original_price <= 5000 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price >=5001 AND pro.discount_price <=10000 ) OR ( pro.original_price >=5001 AND pro.original_price <= 10000 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT COUNT(DISTINCT pro.id) AS pro_count FROM kid_products AS pro LEFT OUTER JOIN kid_products_categories as pc ON ( pro.id = pc.product_id) LEFT OUTER JOIN kid_categories AS c ON (pc.category_id = c.id) WHERE ( ( pro.discount_price > 0 AND pro.show_savings = 1 AND pro.discount_price > 10000 ) OR ( pro.original_price > 10000 AND pro.show_savings = 0 ) ) AND 1 AND (FIND_IN_SET(1, pro.age_category)) AND pro.status = 1 AND pro.rental_product = 0 :
: Error performing query: SELECT id, category FROM kid_categories WHERE parent_id = '' ORDER BY sort_order, group_id, tree_id ASC :
:

category

Error performing query: SELECT * FROM kid_categories WHERE parent_id >= '' ORDER BY sort_order, group_id, tree_id ASC :
: Error performing query: SELECT id, character_theme_name FROM kid_character_themes WHERE status = 1 ORDER BY character_theme_name ASC:
: Error performing query: SELECT DISTINCT id, age FROM kid_age_categories WHERE status = 1 ORDER BY sort_order ASC:
: Error performing query: SELECT id, brand FROM kid_brands WHERE status = 1 ORDER BY brand ASC:
:

Category

    Error performing query: SELECT * FROM kid_categories WHERE parent_id >= '' ORDER BY sort_order, group_id, tree_id ASC :
    :
  • More...
Views: Grid List

Sort By :

No products are found under your search criteria!
Close
Add to Wishlist
Error performing query: SELECT id, name, sort_order FROM kid_wishlist_categories WHERE user_id = '' ORDER BY sort_order ASC :
: Error performing query: SELECT id, name, sort_order FROM kid_wishlist_categories WHERE user_id = '' ORDER BY sort_order ASC :
:

Error closing connection:
: