 |
Categories |
 |
select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Resource id #41
select count(*) as count from categories where parent_id = '24'
Resource id #42
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
Resource id #43
select categories_id from categories where parent_id = '24'
Resource id #44
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
Resource id #45
select categories_id from categories where parent_id = '34'
Resource id #46
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'
Resource id #47
select categories_id from categories where parent_id = '47'
Resource id #48
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
Resource id #49
select categories_id from categories where parent_id = '46'
Resource id #50
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48'
Resource id #51
select categories_id from categories where parent_id = '48'
Resource id #52
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
Resource id #53
select categories_id from categories where parent_id = '49'
Resource id #54
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '114'
Resource id #55
select categories_id from categories where parent_id = '114'
Resource id #56
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '92'
Resource id #57
select categories_id from categories where parent_id = '92'
Resource id #58
select count(*) as count from categories where parent_id = '180'
Resource id #59
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '180'
Resource id #60
select categories_id from categories where parent_id = '180'
Resource id #61
select count(*) as count from categories where parent_id = '182'
Resource id #62
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '182'
Resource id #63
select categories_id from categories where parent_id = '182'
Resource id #64
select count(*) as count from categories where parent_id = '199'
Resource id #65
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '199'
Resource id #66
select categories_id from categories where parent_id = '199'
Resource id #67
select count(*) as count from categories where parent_id = '112'
Resource id #68
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '112'
Resource id #69
select categories_id from categories where parent_id = '112'
Resource id #70
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86'
Resource id #71
select categories_id from categories where parent_id = '86'
Resource id #72
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115'
Resource id #73
select categories_id from categories where parent_id = '115'
Resource id #74
select count(*) as count from categories where parent_id = '150'
Resource id #75
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '150'
Resource id #76
select categories_id from categories where parent_id = '150'
Resource id #77
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '158'
Resource id #78
select categories_id from categories where parent_id = '158'
Resource id #79
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '157'
Resource id #80
select categories_id from categories where parent_id = '157'
Resource id #81
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '159'
Resource id #82
select categories_id from categories where parent_id = '159'
Resource id #83
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '168'
Resource id #84
select categories_id from categories where parent_id = '168'
Resource id #85
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '172'
Resource id #86
select categories_id from categories where parent_id = '172'
Resource id #87
select count(*) as count from categories where parent_id = '184'
Resource id #88
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '184'
Resource id #89
select categories_id from categories where parent_id = '184'
Resource id #90
select count(*) as count from categories where parent_id = '178'
Resource id #91
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '178'
Resource id #92
select categories_id from categories where parent_id = '178'
Resource id #93
select count(*) as count from categories where parent_id = '149'
Resource id #94
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '149'
Resource id #95
select categories_id from categories where parent_id = '149'
Resource id #96
select count(*) as count from categories where parent_id = '131'
Resource id #97
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131'
Resource id #98
select categories_id from categories where parent_id = '131'
Resource id #99
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132'
Resource id #100
select categories_id from categories where parent_id = '132'
Resource id #101
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133'
Resource id #102
select categories_id from categories where parent_id = '133'
Resource id #103
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134'
Resource id #104
select categories_id from categories where parent_id = '134'
Resource id #105
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135'
Resource id #106
select categories_id from categories where parent_id = '135'
Resource id #107
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '136'
Resource id #108
select categories_id from categories where parent_id = '136'
Resource id #109
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138'
Resource id #110
select categories_id from categories where parent_id = '138'
Resource id #111
select count(*) as count from categories where parent_id = '192'
Resource id #112
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '192'
Resource id #113
select categories_id from categories where parent_id = '192'
Resource id #114
select count(*) as count from categories where parent_id = '152'
Resource id #115
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '152'
Resource id #116
select categories_id from categories where parent_id = '152'
Resource id #117
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '169'
Resource id #118
select categories_id from categories where parent_id = '169'
Resource id #119
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '170'
Resource id #120
select categories_id from categories where parent_id = '170'
Resource id #121
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '171'
Resource id #122
select categories_id from categories where parent_id = '171'
Resource id #123
select count(*) as count from categories where parent_id = '203'
Resource id #124
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '203'
Resource id #125
select categories_id from categories where parent_id = '203'
Resource id #126
select count(*) as count from categories where parent_id = '181'
Resource id #127
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '181'
Resource id #128
select categories_id from categories where parent_id = '181'
Resource id #129
select count(*) as count from categories where parent_id = '197'
Resource id #130
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '197'
Resource id #131
select categories_id from categories where parent_id = '197'
Resource id #132
select count(*) as count from categories where parent_id = '147'
Resource id #133
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '147'
Resource id #134
select categories_id from categories where parent_id = '147'
Resource id #135
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '160'
Resource id #136
select categories_id from categories where parent_id = '160'
Resource id #137
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '161'
Resource id #138
select categories_id from categories where parent_id = '161'
Resource id #139
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '162'
Resource id #140
select categories_id from categories where parent_id = '162'
Resource id #141
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '165'
Resource id #142
select categories_id from categories where parent_id = '165'
Resource id #143
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '163'
Resource id #144
select categories_id from categories where parent_id = '163'
Resource id #145
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '164'
Resource id #146
select categories_id from categories where parent_id = '164'
Resource id #147
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '166'
Resource id #148
select categories_id from categories where parent_id = '166'
Resource id #149
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '167'
Resource id #150
select categories_id from categories where parent_id = '167'
Resource id #151
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '204'
Resource id #152
select categories_id from categories where parent_id = '204'
Resource id #153
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '193'
Resource id #154
select categories_id from categories where parent_id = '193'
Resource id #155
select count(*) as count from categories where parent_id = '90'
Resource id #156
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '90'
Resource id #157
select categories_id from categories where parent_id = '90'
Resource id #158
select count(*) as count from categories where parent_id = '200'
Resource id #159
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '200'
Resource id #160
select categories_id from categories where parent_id = '200'
Resource id #161
select count(*) as count from categories where parent_id = '202'
Resource id #162
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '202'
Resource id #163
select categories_id from categories where parent_id = '202'
Resource id #164
select count(*) as count from categories where parent_id = '173'
Resource id #165
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '173'
Resource id #166
select categories_id from categories where parent_id = '173'
Resource id #167
select count(*) as count from categories where parent_id = '206'
Resource id #168
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '206'
Resource id #169
select categories_id from categories where parent_id = '206'
Resource id #170
select count(*) as count from categories where parent_id = '201'
Resource id #171
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '201'
Resource id #172
select categories_id from categories where parent_id = '201'
Resource id #173
select count(*) as count from categories where parent_id = '151'
Resource id #174
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '151'
Resource id #175
select categories_id from categories where parent_id = '151'
Resource id #176
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '153'
Resource id #177
select categories_id from categories where parent_id = '153'
Resource id #178
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '154'
Resource id #179
select categories_id from categories where parent_id = '154'
Resource id #180
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '156'
Resource id #181
select categories_id from categories where parent_id = '156'
Resource id #182
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '155'
Resource id #183
select categories_id from categories where parent_id = '155'
Resource id #184
select count(*) as count from categories where parent_id = '183'
Resource id #185
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '183'
Resource id #186
select categories_id from categories where parent_id = '183'
Resource id #187
select count(*) as count from categories where parent_id = '177'
Resource id #188
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '177'
Resource id #189
select categories_id from categories where parent_id = '177'
Resource id #190
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '188'
Resource id #191
select categories_id from categories where parent_id = '188'
Resource id #192
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '189'
Resource id #193
select categories_id from categories where parent_id = '189'
Resource id #194
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '190'
Resource id #195
select categories_id from categories where parent_id = '190'
Resource id #196
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '191'
Resource id #197
select categories_id from categories where parent_id = '191'
Resource id #198
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '205'
Resource id #199
select categories_id from categories where parent_id = '205'
Resource id #200
select count(*) as count from categories where parent_id = '174'
Resource id #201
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '174'
Resource id #202
select categories_id from categories where parent_id = '174'
Resource id #203
select count(*) as count from categories where parent_id = '175'
Resource id #204
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '175'
Resource id #205
select categories_id from categories where parent_id = '175'
Resource id #206
select count(*) as count from categories where parent_id = '121'
Resource id #207
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121'
Resource id #208
select categories_id from categories where parent_id = '121'
Resource id #209
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122'
Resource id #210
select categories_id from categories where parent_id = '122'
Resource id #211
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123'
Resource id #212
select categories_id from categories where parent_id = '123'
Resource id #213
select count(*) as count from categories where parent_id = '96'
Resource id #214
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '96'
Resource id #215
select categories_id from categories where parent_id = '96'
Resource id #216
select count(*) as count from categories where parent_id = '195'
Resource id #217
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '195'
Resource id #218
select categories_id from categories where parent_id = '195'
Resource id #219
select count(*) as count from categories where parent_id = '196'
Resource id #220
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '196'
Resource id #221
select categories_id from categories where parent_id = '196'
Resource id #222
select count(*) as count from categories where parent_id = '198'
Resource id #223
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '198'
Resource id #224
select categories_id from categories where parent_id = '198'
Resource id #225
select count(*) as count from categories where parent_id = '185'
Resource id #226
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '185'
Resource id #227
select categories_id from categories where parent_id = '185'
Resource id #228
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '186'
Resource id #229
select categories_id from categories where parent_id = '186'
Resource id #230
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '187'
Resource id #231
select categories_id from categories where parent_id = '187'
Resource id #232
select count(*) as count from categories where parent_id = '194'
Resource id #233
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '194'
Resource id #234
select categories_id from categories where parent_id = '194'
Resource id #235
select count(*) as count from categories where parent_id = '179'
Resource id #236
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '179'
Resource id #237
select categories_id from categories where parent_id = '179'
Resource id #238
select count(*) as count from categories where parent_id = '144'
Resource id #239
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144'
Resource id #240
select categories_id from categories where parent_id = '144'
Resource id #241
|