Warning Warning: I am able to write to the configuration file: /home/cbe8171/public_html/mambomart.com/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.
Call: +91-9600696384 Mon-Fri, 9.30 am - 5 pm IST
Advanced Search
Home » Baby Products » Other Baby Products


Other Baby Products

Sort products by
1021 - Disk full (/dev/shm/#sql_4e23_6); waiting for someone to free some space...

select p.products_image, pd.products_description, pd.products_name, pav.free_shipping, c.customers_firstname, sd.store_name, p.products_quantity, pav.shipping_charge, 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 s on p.products_id = s.products_id, products_to_customers pc left join customers_to_stores cs on pc.customers_id = cs.customers_id left join store_details sd on cs.store_id = sd.store_id ,products_to_categories p2c, customers c,products_attribute_values pav where p.products_status = '1' and p.products_listing_status='1' and (p.delete_status='0' or p.delete_status is null) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_id=pc.products_id and p.products_id=pav.products_id and pc.customers_id=c.customers_id and pd.products_id in (select products_id from products_to_categories where categories_id='438' union (select pd.products_id from products_to_categories pc,products_description pd where pc.products_id=pd.products_id and pd.language_id='1' and pc.categories_id in(select categories_id from categories where parent_id in (select categories_id from categories where parent_id='438') union (select categories_id from categories where parent_id='438')))) group by pd.products_id order by pd.products_name limit 0, 5