| |||||||||||||||||
|
|
|
|||||||||||||||||||||||||||||
NEW PRODUCTS
| Displaying 1 to 18 (of 18 products) | Result Pages: 1 |
 DANCING ALIEN $2,056.95 ***OUT OF STOCK*** |  DANCING FRANKENSTEIN $2,444.95 ***OUT OF STOCK*** |  DANCING GHOST $810.95 ***OUT OF STOCK*** |
 DANCING JESTER DOUBLE FAN $2,060.95 ***OUT OF STOCK*** |  DANCING JESTER 16FT SINGLE FAN $1,400.95 ***OUT OF STOCK*** |  DANCING MUMMY $8,074.95 ***OUT OF STOCK*** |
 DANCING SKELETON $4,640.95 ***OUT OF STOCK*** |  DANCING SNAKE $3,432.95 ***OUT OF STOCK*** |  DANCING TUBE 35FT $470.95 ***OUT OF STOCK*** |
 DANCING TUBE SANTA $3,210.95 ***OUT OF STOCK*** |  DANCING TUBE UNCLE SAM $2,060.95 ***OUT OF STOCK*** |  DANCING WITCH $5,150.95 ***OUT OF STOCK*** |
 INFLATABLE 16 FT SKULL $4,590.95 ***OUT OF STOCK*** |  INFLATABLE 20 FT PUMPKIN $4,900.95 ***OUT OF STOCK*** |  INFLATABLE 30 FT DINOSAUR $10,000.95 ***OUT OF STOCK*** |
 SKY KING AIR SYSTEM $1,498.95 ***OUT OF STOCK*** |  SKY KING LITE SYSTEM $120.95 ***OUT OF STOCK*** |  UNICYCLE $170.95  |
| Displaying 1 to 18 (of 18 products) | Result Pages: 1 |
left end: 0.2174 sec
listing start: 0.2189 sec
listing end: 0.4619 sec
END: 0.4628 sec
select p.products_image1, p.description products_name , p.products_id, p.products_price,p.products_price_special, p.products_price final_price from products p , products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and ( p2c.categories_id = '1108' ) group by products_id_group order by p.description