metals recycling

page = search
s_res = GO
stype = all
cq = metals-recycling
qid = 198
const = true
off = 5
rn =
region_id = 0
search = 1
q = metals-recycling
quick = 1

SELECT settings FROM eu_hw_settings

---

SET sql_mode="",time_zone="+01:00";

---

SELECT * FROM eu_modules WHERE state IN("A","I") ORDER BY name

---

INSERT INTO eu_session(session_id,expires,userid,ip,x_forw,data) VALUES("216.73.216.190","1749981151",0,"216.73.216.190","216.73.216.190","") ON DUPLICATE KEY UPDATE expires=VALUES(expires),userid=VALUES(userid),ip=VALUES(ip),x_forw=VALUES(x_forw),data=VALUES(data)

---

SELECT id FROM eu_category LIMIT 1

---

SELECT data FROM eu_session WHERE session_id="psjg9ka68cniil3km9c5g6ramr" AND expires>1748541151

---

SELECT query, link, head_text, foot_text, region_id, region_name_link, region_name, related FROM eu_sq_data WHERE id=198 AND active=1

---

SELECT COUNT(*) FROM eu_field WHERE fset="news"

---

SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT,ATTR,SORTABLE FROM eu_field WHERE fset="news" ORDER BY weight

---

SELECT COUNT(*) FROM eu_field WHERE fset="{user_fields}"

---

SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT,ATTR,SORTABLE FROM eu_field WHERE fset="{user_fields}" ORDER BY weight

---

SELECT * FROM eu_sq_data WHERE `query` LIKE "metals recycling" LIMIT 1

---

SELECT MIN(l.v_price) as min_price, MAX(l.v_price) as max_price FROM eu_ad l WHERE link_id IN (73092,72631,72282,72179,72102,71958,71959,71960,71957,71691,71690,71473,71081,70323,70101,70051,69948,69943,69942,69941,69940,69936,69934,69897,69896,69895,69894,69893,69892,69890,69888,69887,69885,69886,69884,69881,69880,69879,69878,69875,69874,69873,69572,69450,69447,69443,69442,69441,69439,69407,69398,69378,69330,69226,69188,68707,69057,69056,68716,68516,68505,68448,68326,68112,68111,68110,68109,68070,68064,68023,67851,67696,67694,67544,67369,67368,67367,67345,67344,67277,67186,67132,67126,25642,25572,25546,25441,63957,59052,57367,58395,58902,18482,58318,10011,7080,33657,32679,57574,18069,57496,7113,41584,31222,31272,58391,59010,18106,40751,26166,31504,57453,40885,32005,57368,57369,57370,27358,59069,25979,26076,63918,32449,33950,59053,58319,27320,41240,66857,30356,40748,57371,34095,30811,33714,6888,6885,6873,6865,6841,11688,6820,58393,29595,37136,6777,58313,39477,62881,39479,26903,31325,33299,57971,41814,57372,57373,66856,56907,59011,31035,57364,26867,39488,58394,30741,27246,58314,59336,2136,2179,27011,2240,2246,2284,2469,2516,2535,2552,2580,57365,57366,2685,2754,2757,2785,40749,57837,30888,2877,2896,2929,31507,2967,40752,57573,3002,3039,3050,3078,3116,3118,41061,27301,66941,3168,29671,29099,3180,29072,3192,42036,41243,31103,39475,58392,3436,57575,3558,696,3678,675,3719,66151,58315,30357,33871,3806,3810,33350,3901,3914,3985,4023,556,4061,4077,4095,27247,8013,4173,4185,33294,4232,4322,4337,39491,4461,40955,28688,4520,15037,4525,4566,58316,58317,4623,4718,4739,32180,4797,4806,57375,4831,41229,4919,4941,5022,27202,5099,32229,5155,5233,5257,5305,56889,29736,26314,5558,5559,5579,5590,57376,5687,5716,5814,16370,5865,39493,39494,32838,59579,6268,6296,6301,61116,39497,27204,30362,30262,64138,59573,62907,30363,57576,59580,57377)

---

SELECT l.*, case `link_id` when 73092 then 1 when 72631 then 2 when 72282 then 3 when 72179 then 4 when 72102 then 5 when 71958 then 6 when 71959 then 7 when 71960 then 8 when 71957 then 9 when 71691 then 10 when 71690 then 11 when 71473 then 12 when 71081 then 13 when 70323 then 14 when 70101 then 15 when 70051 then 16 when 69948 then 17 when 69943 then 18 when 69942 then 19 when 69941 then 20 when 69940 then 21 when 69936 then 22 when 69934 then 23 when 69897 then 24 when 69896 then 25 when 69895 then 26 when 69894 then 27 when 69893 then 28 when 69892 then 29 when 69890 then 30 when 69888 then 31 when 69887 then 32 when 69885 then 33 when 69886 then 34 when 69884 then 35 when 69881 then 36 when 69880 then 37 when 69879 then 38 when 69878 then 39 when 69875 then 40 when 69874 then 41 when 69873 then 42 when 69572 then 43 when 69450 then 44 when 69447 then 45 when 69443 then 46 when 69442 then 47 when 69441 then 48 when 69439 then 49 when 69407 then 50 when 69398 then 51 when 69378 then 52 when 69330 then 53 when 69226 then 54 when 69188 then 55 when 68707 then 56 when 69057 then 57 when 69056 then 58 when 68716 then 59 when 68516 then 60 when 68505 then 61 when 68448 then 62 when 68326 then 63 when 68112 then 64 when 68111 then 65 when 68110 then 66 when 68109 then 67 when 68070 then 68 when 68064 then 69 when 68023 then 70 when 67851 then 71 when 67696 then 72 when 67694 then 73 when 67544 then 74 when 67369 then 75 when 67368 then 76 when 67367 then 77 when 67345 then 78 when 67344 then 79 when 67277 then 80 when 67186 then 81 when 67132 then 82 when 67126 then 83 when 25642 then 84 when 25572 then 85 when 25546 then 86 when 25441 then 87 when 63957 then 88 when 59052 then 89 when 57367 then 90 when 58395 then 91 when 58902 then 92 when 18482 then 93 when 58318 then 94 when 10011 then 95 when 7080 then 96 when 33657 then 97 when 32679 then 98 when 57574 then 99 when 18069 then 100 when 57496 then 101 when 7113 then 102 when 41584 then 103 when 31222 then 104 when 31272 then 105 when 58391 then 106 when 59010 then 107 when 18106 then 108 when 40751 then 109 when 26166 then 110 when 31504 then 111 when 57453 then 112 when 40885 then 113 when 32005 then 114 when 57368 then 115 when 57369 then 116 when 57370 then 117 when 27358 then 118 when 59069 then 119 when 25979 then 120 when 26076 then 121 when 63918 then 122 when 32449 then 123 when 33950 then 124 when 59053 then 125 when 58319 then 126 when 27320 then 127 when 41240 then 128 when 66857 then 129 when 30356 then 130 when 40748 then 131 when 57371 then 132 when 34095 then 133 when 30811 then 134 when 33714 then 135 when 6888 then 136 when 6885 then 137 when 6873 then 138 when 6865 then 139 when 6841 then 140 when 11688 then 141 when 6820 then 142 when 58393 then 143 when 29595 then 144 when 37136 then 145 when 6777 then 146 when 58313 then 147 when 39477 then 148 when 62881 then 149 when 39479 then 150 when 26903 then 151 when 31325 then 152 when 33299 then 153 when 57971 then 154 when 41814 then 155 when 57372 then 156 when 57373 then 157 when 66856 then 158 when 56907 then 159 when 59011 then 160 when 31035 then 161 when 57364 then 162 when 26867 then 163 when 39488 then 164 when 58394 then 165 when 30741 then 166 when 27246 then 167 when 58314 then 168 when 59336 then 169 when 2136 then 170 when 2179 then 171 when 27011 then 172 when 2240 then 173 when 2246 then 174 when 2284 then 175 when 2469 then 176 when 2516 then 177 when 2535 then 178 when 2552 then 179 when 2580 then 180 when 57365 then 181 when 57366 then 182 when 2685 then 183 when 2754 then 184 when 2757 then 185 when 2785 then 186 when 40749 then 187 when 57837 then 188 when 30888 then 189 when 2877 then 190 when 2896 then 191 when 2929 then 192 when 31507 then 193 when 2967 then 194 when 40752 then 195 when 57573 then 196 when 3002 then 197 when 3039 then 198 when 3050 then 199 when 3078 then 200 when 3116 then 201 when 3118 then 202 when 41061 then 203 when 27301 then 204 when 66941 then 205 when 3168 then 206 when 29671 then 207 when 29099 then 208 when 3180 then 209 when 29072 then 210 when 3192 then 211 when 42036 then 212 when 41243 then 213 when 31103 then 214 when 39475 then 215 when 58392 then 216 when 3436 then 217 when 57575 then 218 when 3558 then 219 when 696 then 220 when 3678 then 221 when 675 then 222 when 3719 then 223 when 66151 then 224 when 58315 then 225 when 30357 then 226 when 33871 then 227 when 3806 then 228 when 3810 then 229 when 33350 then 230 when 3901 then 231 when 3914 then 232 when 3985 then 233 when 4023 then 234 when 556 then 235 when 4061 then 236 when 4077 then 237 when 4095 then 238 when 27247 then 239 when 8013 then 240 when 4173 then 241 when 4185 then 242 when 33294 then 243 when 4232 then 244 when 4322 then 245 when 4337 then 246 when 39491 then 247 when 4461 then 248 when 40955 then 249 when 28688 then 250 when 4520 then 251 when 15037 then 252 when 4525 then 253 when 4566 then 254 when 58316 then 255 when 58317 then 256 when 4623 then 257 when 4718 then 258 when 4739 then 259 when 32180 then 260 when 4797 then 261 when 4806 then 262 when 57375 then 263 when 4831 then 264 when 41229 then 265 when 4919 then 266 when 4941 then 267 when 5022 then 268 when 27202 then 269 when 5099 then 270 when 32229 then 271 when 5155 then 272 when 5233 then 273 when 5257 then 274 when 5305 then 275 when 56889 then 276 when 29736 then 277 when 26314 then 278 when 5558 then 279 when 5559 then 280 when 5579 then 281 when 5590 then 282 when 57376 then 283 when 5687 then 284 when 5716 then 285 when 5814 then 286 when 16370 then 287 when 5865 then 288 when 39493 then 289 when 39494 then 290 when 32838 then 291 when 59579 then 292 when 6268 then 293 when 6296 then 294 when 6301 then 295 when 61116 then 296 when 39497 then 297 when 27204 then 298 when 30362 then 299 when 30262 then 300 when 64138 then 301 when 59573 then 302 when 62907 then 303 when 30363 then 304 when 57576 then 305 when 59580 then 306 when 57377 then 307 end AS `num`, UNIX_TIMESTAMP(l.hw_added) AS fadded,UNIX_TIMESTAMP(l.hw_updated) AS fupdated FROM eu_ad l WHERE link_id IN (73092,72631,72282,72179,72102,71958,71959,71960,71957,71691,71690,71473,71081,70323,70101,70051,69948,69943,69942,69941,69940,69936,69934,69897,69896,69895,69894,69893,69892,69890,69888,69887,69885,69886,69884,69881,69880,69879,69878,69875,69874,69873,69572,69450,69447,69443,69442,69441,69439,69407,69398,69378,69330,69226,69188,68707,69057,69056,68716,68516,68505,68448,68326,68112,68111,68110,68109,68070,68064,68023,67851,67696,67694,67544,67369,67368,67367,67345,67344,67277,67186,67132,67126,25642,25572,25546,25441,63957,59052,57367,58395,58902,18482,58318,10011,7080,33657,32679,57574,18069,57496,7113,41584,31222,31272,58391,59010,18106,40751,26166,31504,57453,40885,32005,57368,57369,57370,27358,59069,25979,26076,63918,32449,33950,59053,58319,27320,41240,66857,30356,40748,57371,34095,30811,33714,6888,6885,6873,6865,6841,11688,6820,58393,29595,37136,6777,58313,39477,62881,39479,26903,31325,33299,57971,41814,57372,57373,66856,56907,59011,31035,57364,26867,39488,58394,30741,27246,58314,59336,2136,2179,27011,2240,2246,2284,2469,2516,2535,2552,2580,57365,57366,2685,2754,2757,2785,40749,57837,30888,2877,2896,2929,31507,2967,40752,57573,3002,3039,3050,3078,3116,3118,41061,27301,66941,3168,29671,29099,3180,29072,3192,42036,41243,31103,39475,58392,3436,57575,3558,696,3678,675,3719,66151,58315,30357,33871,3806,3810,33350,3901,3914,3985,4023,556,4061,4077,4095,27247,8013,4173,4185,33294,4232,4322,4337,39491,4461,40955,28688,4520,15037,4525,4566,58316,58317,4623,4718,4739,32180,4797,4806,57375,4831,41229,4919,4941,5022,27202,5099,32229,5155,5233,5257,5305,56889,29736,26314,5558,5559,5579,5590,57376,5687,5716,5814,16370,5865,39493,39494,32838,59579,6268,6296,6301,61116,39497,27204,30362,30262,64138,59573,62907,30363,57576,59580,57377) ORDER BY `num` ASC LIMIT 12

---

SELECT COUNT(*) FROM eu_field WHERE fset="general"

---

SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT,ATTR,SORTABLE FROM eu_field WHERE fset="general" ORDER BY weight

---

SELECT COUNT(DISTINCT(fset)) FROM eu_category WHERE id IN(807,920,781,809,803,779,677,804)

---

SELECT * FROM eu_user WHERE id IN(26461,5702,25824,25637,21270,25495,25143,24528)

---

SELECT lid,hits FROM eu_hits WHERE lid IN(73092,72631,72282,72179,72102,71958,71959,71960,71957,71691,71690,71473)

---

SELECT images FROM eu_ad WHERE link_id=73092

---

SELECT images FROM eu_ad WHERE link_id=72631

---

SELECT images FROM eu_ad WHERE link_id=72282

---

SELECT images FROM eu_ad WHERE link_id=72179

---

SELECT images FROM eu_ad WHERE link_id=72102

---

SELECT images FROM eu_ad WHERE link_id=71958

---

SELECT images FROM eu_ad WHERE link_id=71959

---

SELECT images FROM eu_ad WHERE link_id=71960

---

SELECT images FROM eu_ad WHERE link_id=71957

---

SELECT images FROM eu_ad WHERE link_id=71691

---

SELECT images FROM eu_ad WHERE link_id=71690

---

SELECT images FROM eu_ad WHERE link_id=71473

---

SELECT COUNT(l.link_id) as reg_count, l.hw_region_id, rc.name as reg_name, rc.iscountry as reg_is FROM eu_ad l LEFT JOIN `eu_regions_category` as `rc` ON `l`.`hw_region_id` = `rc`.`id` WHERE `rc`.`id`<>0 AND l.approved =1 AND l.user_approved =1 AND `rc`.iscountry = 1 AND l.link_id IN (67132,4461,4739,5257,5558,18482,66941,556,675,696,2469,2685,2929,3719,3806,5022,5099,5305,5579,5716,7080,7113,8013,10011,11688,15037,16370,18069,18106,30741,32449,58391,58392,58393,58394,58395,59052,59053,59069,71081,71473,74877,78834,78858,78908,79011,81473,86528,86976,87266,69878,70101,33350,69881,76313,2179,2246,2516,2757,3050,3678,4322,4806,5233,30356,30357,30363,33294,33871,33950,40955,41229,41240,41584,57573,57574,57575,57576,67367,67369,68023,69407,69873,69884,69885,69887,69936,69948,77984,81104,83154,86128,2136,2240,2535,2967,3180,3192,3558,3985,4023,4173,4232,4337,4623,4718,4797,5590,5814,6820,25441,25572,26166,27320,28688,30262,30362,30811,32180,32229,33299,40748,40749,40751,40752,41061,57364,57365,57366,57367,57368,57369,57370,57371,57372,57373,57375,57376,57377,58313,58314,58315,58316,58317,58318,58319,59336,59579,59580,67344,67345,67368,67696,69188,69439,69441,69442,69443,69941,70051,70323,71690,71691,71957,71958,71959,71960,72179,73091,73092,73118,73122,74405,75076,75504,75832,80484,82674,84313,3039,33657,40885,69874,69879,69890,69893,69895,72282,76017,86708,86759,88298,2284,2552,2580,2754,2785,2877,2896,3002,3078,3116,3118,3168,3436,3810,3901,3914,4185,4520,4566,4831,4919,5155,5559,5865,6268,6296,6777,6841,6865,6873,6888,25546,26314,26867,27011,27246,27247,29072,29099,30888,31035,31325,31504,32005,34095,39475,39477,39479,39488,39491,39493,39494,39497,59010,62881,63918,67126,67277,67544,67694,68064,68326,69056,69057,69378,69398,69450,69875,69880,69886,69888,69892,69894,69896,69897,69940,69943,72631,80322,80633,80874,83290,83300,84355,84570,84596,84785,85165,86289,87555,88295,4061,4077,4095,4525,4941,5687,6301,6885,25642,25979,26076,26903,27202,27204,27301,27358,29595,29671,29736,31103,31222,31272,31507,32679,32838,33714,37136,41243,41814,42036,56889,56907,57453,57496,57837,57971,58902,59011,59573,61116,62907,63957,64138,66151,66856,66857,67186,67851,68070,68109,68110,68111,68112,68448,68505,68516,68707,68716,69226,69330,69447,69572,69934,69942,72102,73876,75143,75173,75205,76892,77148,77149,77817,80550,80610,81778,82528,82619,84580,86082,87322,87518,89362,89379) GROUP BY `rc`.id ORDER BY `rc`.`weight` DESC, reg_count DESC LIMIT 9

---

SELECT COUNT(l.link_id) as type_count, eu_category.name FROM eu_ad l LEFT JOIN `eu_regions_category` as `rc` ON `l`.`hw_region_id` = `rc`.`id` LEFT JOIN eu_category ON `l`.`catid` = `eu_category`.`id` WHERE l.approved =1 AND l.user_approved =1 AND l.link_id IN (67132,4461,4739,5257,5558,18482,66941,556,675,696,2469,2685,2929,3719,3806,5022,5099,5305,5579,5716,7080,7113,8013,10011,11688,15037,16370,18069,18106,30741,32449,58391,58392,58393,58394,58395,59052,59053,59069,71081,71473,74877,78834,78858,78908,79011,81473,86528,86976,87266,69878,70101,33350,69881,76313,2179,2246,2516,2757,3050,3678,4322,4806,5233,30356,30357,30363,33294,33871,33950,40955,41229,41240,41584,57573,57574,57575,57576,67367,67369,68023,69407,69873,69884,69885,69887,69936,69948,77984,81104,83154,86128,2136,2240,2535,2967,3180,3192,3558,3985,4023,4173,4232,4337,4623,4718,4797,5590,5814,6820,25441,25572,26166,27320,28688,30262,30362,30811,32180,32229,33299,40748,40749,40751,40752,41061,57364,57365,57366,57367,57368,57369,57370,57371,57372,57373,57375,57376,57377,58313,58314,58315,58316,58317,58318,58319,59336,59579,59580,67344,67345,67368,67696,69188,69439,69441,69442,69443,69941,70051,70323,71690,71691,71957,71958,71959,71960,72179,73091,73092,73118,73122,74405,75076,75504,75832,80484,82674,84313,3039,33657,40885,69874,69879,69890,69893,69895,72282,76017,86708,86759,88298,2284,2552,2580,2754,2785,2877,2896,3002,3078,3116,3118,3168,3436,3810,3901,3914,4185,4520,4566,4831,4919,5155,5559,5865,6268,6296,6777,6841,6865,6873,6888,25546,26314,26867,27011,27246,27247,29072,29099,30888,31035,31325,31504,32005,34095,39475,39477,39479,39488,39491,39493,39494,39497,59010,62881,63918,67126,67277,67544,67694,68064,68326,69056,69057,69378,69398,69450,69875,69880,69886,69888,69892,69894,69896,69897,69940,69943,72631,80322,80633,80874,83290,83300,84355,84570,84596,84785,85165,86289,87555,88295,4061,4077,4095,4525,4941,5687,6301,6885,25642,25979,26076,26903,27202,27204,27301,27358,29595,29671,29736,31103,31222,31272,31507,32679,32838,33714,37136,41243,41814,42036,56889,56907,57453,57496,57837,57971,58902,59011,59573,61116,62907,63957,64138,66151,66856,66857,67186,67851,68070,68109,68110,68111,68112,68448,68505,68516,68707,68716,69226,69330,69447,69572,69934,69942,72102,73876,75143,75173,75205,76892,77148,77149,77817,80550,80610,81778,82528,82619,84580,86082,87322,87518,89362,89379) GROUP BY eu_category.name

---

SELECT `popularity`, `rate`, `query` FROM eu_sq_data WHERE `link` = 'metals-recycling'

---

SELECT `eu_sq_faq`.`question`,`eu_sq_faq`.`answer`, `eu_sq_faq`.`date`, `eu_authors`.`author_name`,`eu_authors`.`author_job_title`,`eu_authors`.`author_image` FROM `eu_sq_faq` LEFT JOIN `eu_authors` ON `eu_sq_faq`.`author_id` = `eu_authors`.`id` WHERE `eu_sq_faq`.`sqid` = '198' ORDER BY `eu_sq_faq`.`id` ASC

---

SELECT COUNT(*) FROM eu_user_online WHERE UNIX_TIMESTAMP(accessdate)>1748540851

---

SELECT COUNT(DISTINCT(ip)) FROM eu_session WHERE expires>1749980851

---

SELECT link_id,v_title,catid,hw_region_id FROM eu_ad WHERE link_id IN(73092,72631,72282,72179,72102,71958,71959,71960,71957,71691,71690,71473)

---