"Back"

SQL Select

Executed SQL
SELECT `t_d`.`entity_id`, `t_d`.`attribute_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_category_entity_varchar` AS `t_d` LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (3, 15, 29, 30, 34, 37, 38, 39, 57, 60, 66, 67, 69, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 111, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 150, 151, 152, 153, 154, 155, 156, 157, 158, 161, 162, 163, 211, 213, 214, 215, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 257, 258)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
entity_id attribute_id default_value store_value value
3 41 WALLPAPER WALLPAPER
3 43 wallpaper wallpaper
15 41 CLOISONNÉ TILES CLOISONNÉ TILES
15 43 cloisonne-tiles cloisonne-tiles
29 41 FURNITURE FURNITURE
29 43 furniture furniture
30 41 By Room By Room
30 43 by-room by-room
34 41 Bedroom Bedroom
34 43 bedroom bedroom
37 41 Dining Room Dining Room
37 43 dining-room dining-room
38 41 Salon Salon
38 43 salon salon
39 41 Library Library
39 43 library library
57 41 By Collection By Collection
57 43 wallpaper-by-collection wallpaper-by-collection
60 41 Chinoiserie 2.0 Chinoiserie 2.0
60 43 chinoiserie chinoiserie
66 41 (About Us) (About Us)
66 43 about-us about-us
67 41 (Discover) (Discover)
67 43 discover discover
69 41 (Curious Minds) (Curious Minds)
69 43 curious-minds curious-minds
70 41 (Craftsmanship) (Craftsmanship)
70 43 craftsmanship craftsmanship
71 41 (Press) (Press)
71 43 press press
73 41 By Category By Category
73 43 by-category by-category
74 41 Tiles Tiles
74 43 tiles tiles
75 41 Boxes Boxes
75 43 boxes boxes
76 41 Trays Trays
76 43 trays trays
77 41 Furnishings Furnishings
77 43 furnishings furnishings
78 41 By Collection By Collection
78 43 by-collection by-collection
79 41 The Oriental Collection The Oriental Collection
79 43 the-oriental-collection the-oriental-collection
80 41 Cabinet of Curiosities Collection Cabinet of Curiosities Collection
80 43 cabinet-of-curiosities-collection cabinet-of-curiosities-collection
81 41 Birds of Paradise Collection Birds of Paradise Collection
81 43 birds-of-paradise-collection birds-of-paradise-collection
82 41 The Reda Amalou Collection The Reda Amalou Collection
82 43 the-reda-amalou-collection the-reda-amalou-collection
83 41 By Category By Category
83 43 furniture-by-category furniture-by-category
84 41 Sofas Sofas
84 43 sofas sofas
85 41 Chairs Chairs
85 43 chairs chairs
86 41 Benches Benches
86 43 benches benches
87 41 Ottomans Ottomans
87 43 ottomans ottomans
88 41 Tables Tables
88 43 tables tables
89 41 Casegoods Casegoods
89 43 casegoods casegoods
90 41 Bedside Tables Bedside Tables
90 43 bedside-tables bedside-tables
91 41 Headboards Headboards
91 43 headboards headboards
92 41 Screens Screens
92 43 screens screens
93 41 Wardrobe Wardrobe
93 43 wardrobe wardrobe
111 41 LIGHTING LIGHTING
111 43 lighting lighting
113 41 Chandeliers Chandeliers
113 43 chandeliers chandeliers
114 41 Table Lamps Table Lamps
114 43 table-lamps table-lamps
115 41 Floor Lamps Floor Lamps
115 43 floor-lamps floor-lamps
116 41 Wall Sconces Wall Sconces
116 43 wall-sconces wall-sconces
117 41 HOME DÉCOR HOME DÉCOR
117 43 home-decor home-decor
118 41 Objects Objects
118 43 objects objects
119 41 Wall Décor Wall Décor
119 43 wall-decor wall-decor
120 41 Softgoods Softgoods
120 43 softgoods softgoods
121 41 Boxes Boxes
121 43 boxes boxes
122 41 Decorative Objects Decorative Objects
122 43 decorative-objects decorative-objects
123 41 Candle Holders Candle Holders
123 43 candle-holders candle-holders
124 41 Trays Trays
124 43 trays trays
125 41 Tabletop Tabletop
125 43 tabletop tabletop
126 41 Picture Frames Picture Frames
126 43 picture-frames picture-frames
127 41 Vanity Vanity
127 43 vanity vanity
128 41 Vases Vases
128 43 vases vases
129 41 Mirrors Mirrors
129 43 mirrors mirrors
130 41 Wall Décor Wall Décor
130 43 wall-decor wall-decor
131 41 Wallpaper Wallpaper
131 43 wallpaper wallpaper
132 41 Beddings Beddings
132 43 beddings beddings
133 41 Pillows Pillows
133 43 pillows pillows
134 41 Throws Throws
134 43 throws throws
135 41 ACCESSORIES & GIFTS ACCESSORIES & GIFTS
135 43 accessories-gifts accessories-gifts
136 41 Accessories Accessories
136 43 accessories accessories
137 41 Gifts Gifts
137 43 gifts gifts
138 41 Jewelry Jewelry
138 43 jewelry jewelry
139 41 Clutches Clutches
139 43 clutches clutches
140 41 Gifts for Her Gifts for Her
140 43 gifts-for-her gifts-for-her
141 41 Gifts for Him Gifts for Him
141 43 gifts-for-him gifts-for-him
142 41 Housewarming Housewarming
142 43 housewarming housewarming
143 41 Wedding Wedding
143 43 wedding wedding
144 41 Graduation Graduation
144 43 graduation graduation
145 41 Seasonal Seasonal
145 43 seasonal seasonal
146 41 (PORTFOLIO) (PORTFOLIO)
146 43 portfolio portfolio
147 41 (Design Service) (Design Service)
147 43 design-service design-service
148 41 (Collaborations) (Collaborations)
148 43 collaborations collaborations
150 41 (Residential Projects) (Residential Projects)
150 43 residential-projects residential-projects
151 41 (Commercial Projects) (Commercial Projects)
151 43 commercial-projects commercial-projects
152 41 (Events) (Events)
152 43 events events
153 41 (Products) (Products)
153 43 products products
154 41 (Locate) (Locate)
154 43 locate locate
155 41 (Shop) (Shop)
155 43 shop shop
156 41 (PARTNERS) (PARTNERS)
156 43 partners partners
157 41 (BOUTIQUES) (BOUTIQUES)
157 43 boutiques boutiques
158 41 (Contact) (Contact)
158 43 contact contact
161 41 (The Tale) (The Tale)
161 43 the-tale the-tale
162 41 (Wholesale) (Wholesale)
162 43 wholesale wholesale
163 41 (Enquiries) (Enquiries)
163 43 enquiry enquiry
211 41 (Get Inspired) (Get Inspired)
211 43 get-inspired get-inspired
213 41 Embellishments Embellishments
213 43 embellishments embellishments
214 41 Flora and Fauna Flora and Fauna
214 43 flora-and-fauna flora-and-fauna
215 41 Wonder Pearls Wonder Pearls
215 43 wonder-pearls wonder-pearls
244 41 BLOG BLOG
244 43 blog blog
245 41 Seasonal Seasonal
245 43 seasonal seasonal
246 41 LALA CURIO Events LALA CURIO Events
246 43 lala-curio-events lala-curio-events
247 41 LALA CURIO Products LALA CURIO Products
247 43 lala-curio-products lala-curio-products
248 41 Dinner for Two Dinner for Two
248 43 dinner-for-two dinner-for-two
249 41 Chinese New Year Chinese New Year
249 43 chinese-new-year chinese-new-year
250 41 Valentine Day Special Gifts Valentine Day Special Gifts
250 43 valentine-day-special-gifts valentine-day-special-gifts
251 41 LALA Brunch LALA Brunch
251 43 lala-brunch lala-brunch
252 41 Paris Blog Paris Blog
252 43 paris-blog paris-blog
253 41 Wallpaper Guide Wallpaper Guide
253 43 wallpaper-guide wallpaper-guide
254 41 African Tribal Blog African Tribal Blog
254 43 african-tribal-blog african-tribal-blog
257 41 Chinoiserie 2.0 Blog Chinoiserie 2.0 Blog
257 43 chinoiserie-chez-blog chinoiserie-chez-blog
258 41 Reinventing Cloisonne Reinventing Cloisonne
258 43 reinventing-cloisonne reinventing-cloisonne