Back to the Query Overview

Executed SQL

Statement
SELECT shop.shop_id AS shop_shop_id, shop.shop_name AS shop_shop_name, shop.phone_number AS shop_phone_number, shop.email AS shop_email, shop.address_line1 AS shop_address_line1, shop.address_line2 AS shop_address_line2, shop.city_id AS shop_city_id 
FROM shop
Time0.4170 ms
Parameters{}

Query Results

SHOP_SHOP_IDSHOP_SHOP_NAMESHOP_PHONE_NUMBERSHOP_EMAILSHOP_ADDRESS_LINE1SHOP_ADDRESS_LINE2SHOP_CITY_ID
206Calicut Wud Bank8593839797Calicut Wud Bank188
37Uniwood9633700044Uniwood57
49Namia 9847219265Namia 66
1Kottayam glass house9249413303Kottayam glass house25
2Union glass house9447208886Union glass house26
3Olive glass house9048813577Olive glass house27
4Alans plywood&glass9744844622Alans plywood&glass28
5Kairali glass house9037701950Kairali glass house29
6Vattekattu glass house9447601032Vattekattu glass house30
7Variyath glass house9447361998Variyath glass house28
8Bharath glass house9447367306Bharath glass house31
9Pj glass house9447493312Pj glass house32
10Pobson enterprices9562918619Pobson enterprices33
11Wiwa associates9847286680Wiwa associates34
12Central glass house9895020491Central glass house26
13Nirmal glass house9846047712Nirmal glass house26
14Sm glass house9495686872Sm glass house25
15Saraswathi glass house8075550761Saraswathi glass house35
16Asain glass house9446135439Asain glass house36
17Mankamathanam glass9847768857Mankamathanam glass37
18Nandana glass house9846510276Nandana glass house38
19Travancore glass & plywoods9847203232Travancore glass & plywoods39
20Bharath glass house9497618481Bharath glass house40
21Nandoos glass house9895457812Nandoos glass house41
22Sai glass house9400474669Sai glass house42
23Parapuzha glass house9605020003Parapuzha glass house43
24Sj hardwares9447440238Sj hardwares44
25Achoos glass house9447860871Achoos glass house45
28Thazhchayil glass house9446065605Thazhchayil glass house48
29Empire glass house9447660494Empire glass house49
30Jiss glass house9446203451Jiss glass house50
31Ca glass house9447851245Ca glass house51
32Koyikal glass house9446116262Koyikal glass house52
334 Homes94958754164 Homes53
34Pannuvelil glass house9895020491Pannuvelil glass house54
35Orient glass house9447419390Orient glass house55
36Tharayil glass house9745821746Tharayil glass house56
38Arafa glass house8547740207Arafa glass house58
39Nubra glass9526340004Nubra glass59
40Ayinikkottil glass house9333645060Ayinikkottil glass house60
41Art and craft9400040898Art and craft61
42National traders9446301180National traders62
43Diamond ply wood8086557799Diamond ply wood63
44Akt glass house9539600072Akt glass house64
45Taj glass house9744750000Taj glass house65
46Ply lam agencies7736221716Ply lam agencies65
47Mak plywood9349112686Mak plywood65
48Wood ply9539838366Wood ply66
50Tp tiles9562995516Tp tiles67
51Thenugal glass4936220048Thenugal glass68
52Paint house9747576499Paint house69
53Calicut ply9447009797Calicut ply70
54C m mathew sons4952727818C m mathew sons70
55Deco Plywoods 9496622071Deco Plywoods 71
56Krishna glass & plywoods9961999180Krishna glass & plywoods72
57Maliyekal glass & plywoods9895431437Maliyekal glass & plywoods73
58S B Glass & plywoods9447218963S B Glass & plywoods74
61K N Trading Co.9061055128K N Trading Co.77
64Crescent Glass & Plywoods9846042397Crescent Glass & Plywoods80
68Cochin Glass House9496090001Cochin Glass House84
69Mayura Agencies 9847292965Mayura Agencies 85
70Bharath Glass House9496090003Bharath Glass House85
71Code Viera Traders 9995077422Code Viera Traders 86
72Fine Glass & Plywoods 9496090002Fine Glass & Plywoods 87
73Kachappally Agencies 9495315931Kachappally Agencies 88
74Kaitharan Glass & Plywoods 8129100527Kaitharan Glass & Plywoods 89
75Kaitharan Glass & Plywoods 8129100524Kaitharan Glass & Plywoods 90
76Kalady Glass House9544981112Kalady Glass House91
77Glass world9745002929Glass world92
78St.joseph glass & plywoods9447833356St.joseph glass & plywoods93
79United glass emporium7558991000United glass emporium94
80Pulikkan traders9400643032Pulikkan traders95
81E.V.Porinchu & co4872342906E.V.Porinchu & co96
82Cannanore traders9447524705Cannanore traders97
83Chirakkekkaran glass house9387741081Chirakkekkaran glass house97
84Vimala plywoods9847860207Vimala plywoods97
85PLY land & hardware9447308946PLY land & hardware97
86Thekkath plywood corner4872335771Thekkath plywood corner97
87Trichur ply house8137990903Trichur ply house97
88Vazhappilly glass& plywood85473213593Vazhappilly glass& plywood98
89R.J plywoods & laminates9633522444R.J plywoods & laminates99
90Chirakekaran glass house9847941082Chirakekaran glass house100
91St. George plywoods8086217451St. George plywoods101
92New grant glass & plywoods9496215350New grant glass & plywoods102
93Varna traders9496064222Varna traders103
94Unity distributors8137990905Unity distributors104
95Mas traders7403111333Mas traders105
96Ply wood house9249976179Ply wood house106
97Athira glass house9447422050Athira glass house107
98Coimbatore traders7558093332Coimbatore traders106
100Imperial glass9605654167Imperial glass109
101Arafa glass9447030258Arafa glass110
102East india plywood9790862696East india plywood111
103Siva ram enterprises9895319005Siva ram enterprises111
104Prime plywood9447372486Prime plywood111
105Appans glass9961061243Appans glass112
106Metalex traders8592825802Metalex traders113
107Kohinoor glass9447549524Kohinoor glass114
108Chillukada9447519295Chillukada115
109Glass palace9747223275Glass palace115
110Pkk agency9447071659Pkk agency116
111Mattanur glass9539027048Mattanur glass116
112Sky glass9447648670Sky glass117
113Lakshmi glass9895423762Lakshmi glass117
114Sky associate9744317206Sky associate118
115Glassco9895241416Glassco119
116Safrone ply9037765321Safrone ply120
117Greenland9847287089Greenland121
118K I abdulsathar9995188886K I abdulsathar122
119Empire plywood9746410242Empire plywood122
121A one glass9400297786A one glass124
123Hi tech glass9447438230Hi tech glass126
124Central glass9447066494Central glass127
125City glass9544446363City glass127
126Glass emporium9847911933Glass emporium127
127Galaxy agency9961461733Galaxy agency128
128Galaxy agency9847078774Galaxy agency129
130Jasmine hardwares9446596091Jasmine hardwares131
131Glass palace9447229018Glass palace132
132Nova glass9656558300Nova glass132
133KK glass8547204819KK glass132
134New glass9544078231New glass133
136Royal star plywoods9562743982Royal star plywoods135
137Basheer glass9447321936Basheer glass136
138Glass palace9526411947Glass palace137
207Aswathywud9447716985Aswathywud188
140Bright glass8129044353Bright glass139
142Sheeba glass4985260132Sheeba glass140
143Neelagiri funiture9961445522Neelagiri funiture141
144Chillumeda 7025935347Chillumeda 141
145Golden plywoods9496177747Golden plywoods141
146Glass india9961545478Glass india142
147Jasmine plywoods9446570771Jasmine plywoods143
148Mariyum agency9946340945Mariyum agency144
149Belgium glass9447009423Belgium glass145
150Surabhi glass9847072248Surabhi glass146
152Maruthi glass & plywoods9495616865Maruthi glass & plywoods148
153Maruthi glass & plywoods9495616865Maruthi glass & plywoods149
154Maruthi glass & plywoods9539090623Maruthi glass & plywoods150
155BM paints9747988883BM paints151
156Surabhi glass9946462114Surabhi glass152
157Royal india tools9447684598Royal india tools153
158Metro trading9995611461Metro trading154
159Safeline plywoods9400663313Safeline plywoods155
160Sana glass & plywoods9895217030Sana glass & plywoods156
161Magic shopee9633000393Magic shopee157
162Barath plywoods9895117720Barath plywoods157
163Sreekrishnahardwares9447384664Sreekrishnahardwares157
164Sandhya plywoods9447653771Sandhya plywoods157
165Koottudan plywoods4998214000Koottudan plywoods158
166City glass9995848963City glass159
167Al madheena paints9995176488Al madheena paints159
168Bharath glass9895494620Bharath glass161
209Rosheel Enterprises9847191512Rosheel Enterprises190
210Shine woods9495815141Shine woods45
120Lembeth7558994623Lembeth123
122Naziem9846154636Naziem125
129J. teck 9446262691J. teck130
135Krishna9947003472Krishna134
141Sheeba4672211482Sheeba139
151New india 9895328766New india 147
211Jay Jay Glass Emporium9847098669Jay Jay Glass Emporium163
213Jacwud interior store8589921155Opp. Deshabhimani Poonkunnam, Thrissur191
212Jacwud interior store8589921155Opp. Deshabhimani Poonkunnam,Thrissur97
214ABees Interiors9562077094Edamuttam P.O., Thavalakulam Junction, Kazhimbram, Trichur-680568.192
208Oriental Glass & Plywoods9995071077Oriental Glass & Plywoods189
200Trades India 9895854163Trades India 185
169Sreevarahan Traders4712476732Sreevarahan Traders162
170House Point9847867728House Point163
171Glass Point9847108394Glass Point162
172Merrina Agencies9446039994Merrina Agencies162
173Alince GlassAlince Glass164
174Kerala Glass House9447461772Kerala Glass House165
175Sreelakshmi Agencies9961178487Sreelakshmi Agencies165
176Sunil Glass Emporium9447060869Sunil Glass Emporium165
177Classic Hardwares9846331145Classic Hardwares166
178Aiswarya Glass House9495039075Aiswarya Glass House167
179Sanooj Enterprises9037182942Sanooj Enterprises168
180Glass Point9846673037Glass Point169
181Punchiri Glass9447102886Punchiri Glass169
183Kailas Enterprises9447270408Kailas Enterprises168
197Real Glass9447772931Real Glass183
139Glass mahal9447449037Glass mahal115
198Elavakattu glass house9847032189Elavakattu glass house184
182Prasanth Paints8589056631Prasanth Paints170
184Primier Glass 8589056631Primier Glass 171
185R B Agencies7034444355R B Agencies172
186MAM Traders9446663931MAM Traders173
187New Prince Glass9747125029New Prince Glass174
188Choice Paints9847605543Choice Paints175
189Indian Glass HouseIndian Glass House176
190Anjana Glass9495703078Anjana Glass177
191Sreekrishna Agencies9961788977Sreekrishna Agencies178
192Sreekrishna Agencies8281338977Sreekrishna Agencies179
193WE ONE Glass8086433716WE ONE Glass180
194Paravoor Glass House9744652848Paravoor Glass House181
195S S MookambikaS S Mookambika182
199VeeJay Enterprises 9447818255VeeJay Enterprises 185