SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2021-03-01 10:41:48')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 183)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
5311 REBEL8 WORLD CHAMPS MENS TEE Black
9781 REBEL8 CONCRETE VANDALS BLACK TEE BLK
11110 REBEL8 STANDARD ISSUE LOGO NEW ERA
11131 REBEL8 STANDARD ISSUE LOGO PULLOVER
11135 REBEL8 LUXURY TAX BLACK TEE
11139 REBEL8 STANDARD ISSUE LOGO BLACK TEE
11769 REBEL8 LEADERS OF THE PACK BLACK TEE
11770 REBEL8 TRUSTED LEADERS BLACK TEE
11772 REBEL8 FIGHT THE POWER BLACK TEE
12992 REBEL8 STANDARD ISSUE LOGO WHITE TEE
13767 REBEL8 WOMENS BLACK LOGO TEE
15288 REBEL8 WOMENS RIBBON FLOW PULLOVER
15291 REBEL8 WATCH YOUR STEP BLACK TEE
15292 REBEL8 WOMENS WATCH YOUR STEP BUTTON-UP
16568 REBEL8 WOMENS HI-RISE INDIGO JEAN
16574 REBEL8 WOMENS KILLA KOLLAGE TEE
16578 REBEL8 BACKLOT BLACK TEE
16873 REBEL8 CROSSBONES BLACK TEE
16875 REBEL8 APOCALYPSE BURGUNDY TEE
17994 REBEL8 FREEDOM WHITE TEE
17995 REBEL8 FREEDOM BLACK TEE
18011 REBEL8 ALPINE RUST BEANIEMADE AND PAID GREY TEE
20190 REBEL8 RAVENS BLACK
20192 REBEL8 THE 8 HOPS
20282 REBEL8 WOMENS BOLTED VARSITY JACKET
20302 REBEL8 NECK DEEP BLACK TEE
20303 REBEL8 GR8FUL TEE
22070 REBEL8 MASS DISRUPTION WHITE TEE
22079 REBEL8 AVI8TOR WHITE TEE
22080 REBEL8 AVI8TOR BLACK TEE
22081 REBEL8 WOMENS NIGHT WATCH PULLOVER HOODIE
22085 REBEL8 PRESS YOUR LUCK BLACK TEE
22228 REBEL8 Standard Issue Logo Crewneck
22911 REBEL8 TAP THE ROCKIES BLACK TEE
22912 REBEL8 TAP THE ROCKIES GREY TEE
22914 REBEL8 ETERNAL BROTHERHOOD BLACK TEE
22918 REBEL8 PROPERTY OF BLACK TEE
22919 REBEL8 PROPERTY OF PULLOVER HOODIE
22927 REBEL8 RIOT REGULATORS BLACK TEE
22928 REBEL8 RUINERS WHITE TEE
22929 REBEL8 RUINERS BLACK TEE
22937 REBEL8 BLOCK COLLAGE BLACK TEE
22939 REBEL8 STANDARD ISSUE BLACK TANK
22940 REBEL8 STANDARD ISSUE WHITE TANK
23261 REBEL8 WOMENS INSTROSPECTIVE RAIN JACKET
23263 REBEL8 SECRET ALLEGIANCE BLACK TEE
24165 REBEL8 GOOD CRIMES BLACK TEE
24166 REBEL8 GOOD CRIMES HEATHER CHARCOAL TEE
24170 REBEL8 HIGH STRIKER BLACK TEE
24817 REBEL8 REBEL8 X IRONLAK WHITE TEE
25020 REBEL8 PREMIUM BLEND S/S TEE BLACK
25026 REBEL8 BASIC S/S TEE BLACK
25043 REBEL8 HOOD WATCH S/S TEE WHITE
25126 REBEL8 DOMESTIC DESTRUCTION S/S TEE BLACK
25130 REBEL8 BOTTLE OPENER SILVER
25131 REBEL8 BOTTLE OPENER GOLD
25354 REBEL8 WOMENS LO-RISE INDIGO JEAN
25355 REBEL8 WOMENS HI-RISE BLACK JEAN
28139 REBEL8 BOVVER BLACK POLO
28197 REBEL8 STRIKE TWICE BLACK TEE
28199 REBEL8 BOMB SQUAD ARMY TEE
28203 REBEL8 BOMB SQUAD BLACK TEE
28205 REBEL8 CIGARILLO BLACK TEE
28215 REBEL8 WOMENS BUFFALO STANCE COAT
28219 REBEL8 WOMENS CONSPIRACY SHORT SLEEVE CREWNECK
28227 REBEL8 BOMB SQUAD EMBROIDERED BLACK CREWNECK
28882 REBEL8 GRIM BLACK TEE
28886 REBEL8 STANDING STRONG BLACK TEE
29866 REBEL8 WOMENS BEAT IT RAGLAN
29882 REBEL8 CONJURING WHITE TEE
29891 REBEL8 ORNATE BADGE WHITE TEE
29892 REBEL8 DESCANSO ETERNO BLACK TEE
29893 REBEL8 DESCANSO ETERNO WHITE TEE
29894 REBEL8 MAKERS AND BREAKERS BURGUNDY TEE
29906 REBEL8 MAKERS AND BREAKERS WHITE TEE
29909 REBEL8 WORLDWIDE DISTRO BLACK TEE
29910 REBEL8 WORLDWIDE DISTRO HEATHER GREY TEE
29911 REBEL8 MAKERS AND BREAKERS RAGLAN
31789 REBEL8 STANDARD FIT PANT BLACK DENIM
32329 REBEL8 SKATE CORE BURNOUT TEE
32332 REBEL8 DEAD ASLEEP TEE BURGUNDY
32335 REBEL8 CONFIDE IN NONE SOFT TEE BLACK
32350 REBEL8 HELL BOUND WHITE TEE
32352 REBEL8 CURB RATS BLACK TEE
32362 REBEL8 OFF THE RAILS BLACK TEE
32363 REBEL8 OFF THE RAILS GREY TEE
32373 REBEL8 EIGHT OR DIE TEE
32375 REBEL8 ROSE AND DAGGERS SOFT BLACK TEE
32383 REBEL8 TOAST TO THE WORST POCKET BLACK TEE
33470 REBEL8 PARANOID TEE BLACK
33479 REBEL8 BOTTLED VIOLENCE SOFT TEE BLACK
33486 REBEL8 SKELETONS OF SOCIETY MINERAL WASH TEE
33487 REBEL8 BREWED AND SCREWED TEE
33494 REBEL8 PROPER FUCKED POLO
33598 REBEL8 BREWED AND SCREWED PULLOVER HOODIE
33599 REBEL8 PREMIUM SCRIPT TEE BLACK
33999 REBEL8 SUBSIST TEE
34467 REBEL8 BOGEY STRAPBACK PINK
35077 REBEL8 Dalmae Slouchy Tank
35078 REBEL8 Down The Hatch Racerback Tank
35079 REBEL8 Water Hazard Embroidered Roll Sleeve Tee
35084 REBEL8 Lakeview Embroidered Tank
35088 REBEL8 Designs Cropped Raglan
35093 REBEL8 Lakeview Embroidered Pocket Ladies Tee Black
35094 REBEL8 Lakeview Embroidered Pocket Ladies Tee White
35165 REBEL8 Por Vida Tee Black
35167 REBEL8 x James Jirat Romance Tee
35168 REBEL8 Logo Chest Tank White
35169 REBEL8 Logo Chest Tank Black
35170 REBEL8 x James Jirat Hellhound Tee
35541 REBEL8 Discarded Paradise Snapback
36373 REBEL8 Phone Case
36378 REBEL8 Rubber Coin Case 8 Logo
36726 REBEL8 Overspray Tee
36727 REBEL8 Serramonte Longsleeve Tee
36728 REBEL8 Coney Longsleeve Tee White
36729 REBEL8 Coney Longsleeve Tee Black
36730 REBEL8 Floret Embroidered Crewneck
37728 REBEL8 Sanctified Raglan
37729 REBEL8 Foretold Pullover Hoodie
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => rebel8
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/rebel8/
--------
mb_parse_str
Array
(
[brand_name] => rebel8
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=rebel8&/