Baqala

   
0item(s)

You have no items in your shopping cart.

 

Product was successfully added to your shopping cart.

Snacks     View 1114 more >

SELECT `e`.*, IF(at_image.value_id > 0, at_image.value, at_image_default.value) AS `image`, `catalog_category_product`.`category_id`, `catalog_category_product`.`position`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_varchar` AS `at_image_default` ON (`at_image_default`.`entity_id` = `e`.`entity_id`) AND (`at_image_default`.`attribute_id` = '85') AND `at_image_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_image` ON (`at_image`.`entity_id` = `e`.`entity_id`) AND (`at_image`.`attribute_id` = '85') AND (`at_image`.`store_id` = 1) LEFT JOIN `catalog_category_product` ON (catalog_category_product.product_id =e.entity_id) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_image.value_id > 0, at_image.value, at_image_default.value) != 'selection') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (catalog_category_product.category_id IN(334)) ORDER BY `catalog_category_product`.`position` desc

Beverages     View 423 more >

SELECT `e`.*, IF(at_image.value_id > 0, at_image.value, at_image_default.value) AS `image`, `catalog_category_product`.`category_id`, `catalog_category_product`.`position`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_varchar` AS `at_image_default` ON (`at_image_default`.`entity_id` = `e`.`entity_id`) AND (`at_image_default`.`attribute_id` = '85') AND `at_image_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_image` ON (`at_image`.`entity_id` = `e`.`entity_id`) AND (`at_image`.`attribute_id` = '85') AND (`at_image`.`store_id` = 1) LEFT JOIN `catalog_category_product` ON (catalog_category_product.product_id =e.entity_id) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_image.value_id > 0, at_image.value, at_image_default.value) != 'selection') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (catalog_category_product.category_id IN(347)) ORDER BY `catalog_category_product`.`position` desc