SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (70, 84, 85, 86, 106, 107, 108, 114, 117, 170, 188, 190, 192, 885, 976, 1071, 1735, 1736, 1744, 1745, 1751, 1773, 1777, 1782, 1783, 1796, 1799, 1800, 1821, 1992, 2068)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (75, 79, 113, 191, 962, 1776, 1886, 1887, 1991, 1994)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (76, 77)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (90, 94, 171, 189, 951, 952, 953, 968, 1227, 1482, 1486, 1490, 1549, 1559, 1563, 1601, 1602, 1639, 1645, 1709, 1710, 1725, 1737, 1746, 1747, 1756, 1772, 1775, 1781, 1784, 1793, 1795, 1801, 1806, 1823, 1865, 1878, 1888, 1892, 1899, 1910, 1973, 1975, 1976, 1977, 1978, 1980, 1981, 1982, 1983, 1988, 1989, 2048, 2049, 2050, 2060, 2063, 2067, 2080, 2081, 2082, 2083, 2084, 2088, 2096, 2097)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (1711, 1792, 1798, 1811, 1867, 1871)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) Home Appliances Small Kitchen supplies at the best prices from B.TECH | Category page
Shop By
Shopping Options
Brand
  1. Momenta 3 products
  2. SF 400 1 Item
  3. Ariete 15 products
  4. Ariston 14 products
  5. Atlantic 17 products
  6. BaByliss 19 products
  7. Beko 29 products
  8. Bergen 6 products
  9. Black + Decker 126 products
  10. Braun 122 products
  11. Daewoo 11 products
  12. Delonghi 43 products
  13. Electrostar 1 Item
  14. Fresh 179 products
  15. Hitachi 2 products
  16. Home 31 products
  17. Huawei 0 products
  18. Indesit 1 Item
  19. JAC 11 products
  20. Kenwood 96 products
  21. Kiriazi 5 products
  22. Koldair 7 products
  23. LG 12 products
  24. Midea 6 products
  25. Miele 10 products
  26. Mienta 111 products
  27. Modex 8 products
  28. Moulinex 72 products
  29. Nespresso 2 products
  30. Olympic Electric 22 products
  31. Philips 31 products
  32. Samsung 10 products
  33. Sary 4 products
  34. Sharp 28 products
  35. Tank 56 products
  36. Tefal 37 products
  37. Tornado 219 products
  38. Toshiba 20 products
  39. Unionaire 8 products
  40. Universal 6 products
  41. White Whale 6 products
  42. Zanussi 18 products
  43. ULTRA 25 products
  44. Xiaomi 4 products
  45. Hoover 15 products
  46. Bosch 94 products
  47. Cobra 1 Item
  48. Panasonic 61 products
  49. Rose 0 products
  50. MediaTech 35 products
  51. ATA 3 products
  52. Kumtel 5 products
  53. ETI 1 Item
  54. Black And White 31 products
  55. Grouhy 6 products
  56. Bissell 2 products
  57. Hikvision 1 Item
  58. Zada 7 products
  59. Sasho 1 Item
  60. Sencor 1 Item
  61. AKAI 16 products
  62. Smart 24 products
  63. General 2 products
  64. Touch El Zenouky 25 products
  65. Grand 4 products
  66. Dahua 2 products
  67. Prifix 19 products
  68. Tiger 2 products
  69. Epson 1 Item
  70. Rony 1 Item
  71. Arzum 17 products
  72. Sonai 107 products
  73. D-Link 1 Item
  74. Heller 1 Item
  75. Nikai 1 Item
  76. Dremel 5 products
  77. Castle 60 products
  78. Nouval 5 products
  79. Moser 1 Item
  80. Saturn 1 Item
  81. Arion 18 products
  82. Rush Brush 7 products
  83. Camelion 2 products
  84. Remington 1 Item
  85. Kemei 7 products
  86. Hoho 3 products
  87. G.Tec 0 products
  88. MPT 1 Item
  89. Brother 15 products
  90. Claber 1 Item
  91. iHome 4 products
  92. Natural Sky 2 products
  93. Uno 1 Item
  94. Beurer 5 products
  95. Passap 2 products
  96. Veito 5 products
  97. Sinbo 1 Item
  98. More 4 products
  99. Rozia 1 Item
  100. Aqua 3 products
  101. Aqua Jet 2 products
  102. Aquavit 1 Item
  103. Carnival 4 products
  104. Sonifer 9 products
  105. Venezia 1 Item
  106. Caso 3 products
  107. British Berkefeld 2 products
  108. Sokany 199 products
  109. S Smart 14 products
  110. Taurus 2 products
  111. City 10 products
  112. VGR 3 products
  113. Magefesa 1 Item
  114. Simfer 8 products
  115. Dongcheng 1 Item
  116. Ingco 2 products
  117. NOVOVENT 1 Item
  118. Hopson 1 Item
  119. Solac 2 products
  120. Total 23 products
  121. Crown 2 products
  122. New Yorker 1 Item
  123. Calpeda 1 Item
  124. Kandoz 3 products
  125. Pedrollo 1 Item
  126. Flyon 4 products
  127. Golden 1 Item
  128. Eufy 1 Item
  129. Soul 1 Item
  130. Baltgaz 3 products
  131. Fit 6 products
  132. Akel 3 products
  133. Bravo 2 products
  134. Aquaturk 26 products
  135. Fluxtek 2 products
  136. Electro Gold 1 Item
  137. DSP 20 products
  138. Joc 1 Item
  139. Lsjy 3 products
  140. Long Life 1 Item
  141. High Way 2 products
  142. Huayu 1 Item
  143. Genwex 1 Item
  144. Flamingo 1 Item
  145. Belong 1 Item
  146. I Tech Solution 1 Item
  147. Danata 1 Item
  148. Rovo 3 products
  149. Touch 8 products
  150. Total Tools 1 Item
  151. ADT 3 products
  152. SSmart 2 products
  153. Starget 23 products
  154. ZKTeco 1 Item
  155. Sunmi 2 products
  156. Xprinter 1 Item
  157. SPRT 1 Item
  158. Casio 7 products
  159. Deli 5 products
  160. APT 1 Item
  161. Arshia 1 Item
  162. Nardi 3 products
  163. 3S 1 Item
  164. Ferroli 3 products
  165. Nutricook 7 products
  166. Starmax 2 products
  167. Maxell 1 Item
  168. Ocean 1 Item
  169. Syble 1 Item
  170. Gorenje 1 Item
  171. Akwrj 1 Item
  172. National 6 products
  173. Green Lion 1 Item
  174. Fulgor 2 products
  175. Bismarck 5 products
  176. IDO 22 products
  177. Fine 1 Item
  178. Realand Bio 1 Item
  179. Levon 13 products
  180. Aura 2 products
  181. IID 2 products
  182. Twisted Mind 1 Item
  183. Raf 10 products
  184. Ace 1 Item
  185. Essse 6 products
  186. Skimo 1 Item
  187. Inverterteck 4 products
  188. Aiax 4 products
  189. DESSINI 1 Item
  190. Generic 81 products
  191. Dream 2 products
  192. Fujitsu 4 products
  193. BTC 1 Item
  194. Cemsan 5 products
  195. TankPac 1 Item
  196. Horse Power 1 Item
  197. Water World 1 Item
  198. Lex Pure 1 Item
  199. Watermust 1 Item
  200. Blue Sky 1 Item
  201. Flamngo 4 products
  202. Rafal 6 products
  203. Smith 1 Item
  204. Baseus 1 Item
  205. Segafredo 2 products
  206. Alb 2 products
  207. Black Stone 16 products
  208. One Life 5 products
  209. Metro 1 Item
  210. Optima 1 Item
  211. Heiss 2 products
  212. Inverter Tech 1 Item
  213. Uten 1 Item
  214. Electrolux 1 Item
  215. KitchenAid 4 products
  216. Catosio 1 Item
  217. Feian 1 Item
  218. Dansha 2 products
  219. Armadillo 7 products

Small Home Appliances

0
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (70, 84, 85, 86, 106, 107, 108, 114, 117, 170, 188, 190, 192, 885, 976, 1071, 1735, 1736, 1744, 1745, 1751, 1773, 1777, 1782, 1783, 1796, 1799, 1800, 1821, 1992, 2068)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (75, 79, 113, 191, 962, 1776, 1886, 1887, 1991, 1994)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (76, 77)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (90, 94, 171, 189, 951, 952, 953, 968, 1227, 1482, 1486, 1490, 1549, 1559, 1563, 1601, 1602, 1639, 1645, 1709, 1710, 1725, 1737, 1746, 1747, 1756, 1772, 1775, 1781, 1784, 1793, 1795, 1801, 1806, 1823, 1865, 1878, 1888, 1892, 1899, 1910, 1973, 1975, 1976, 1977, 1978, 1980, 1981, 1982, 1983, 1988, 1989, 2048, 2049, 2050, 2060, 2063, 2067, 2080, 2081, 2082, 2083, 2084, 2088, 2096, 2097)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1682027940' AND e.updated_in > '1682027940') LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (402417, 401823, 401681, 401630, 401623, 401594, 401479, 401468, 400670, 400652, 400651, 400401, 401989, 401990, 401991)) AND (t_d.attribute_id IN (1711, 1792, 1798, 1811, 1867, 1871)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))