LEOTARD CHILD SCOOP S S $18.95 *OUT OF STOCK*	LEOTARD ECO SPAG STRAP CHILD $20.95 *OUT OF STOCK*	LEOTARD TURTLENECK CHILD $31.95 *OUT OF STOCK*
PANT TIGHTS FOOTLESS X $40.95 *OUT OF STOCK*	SKIRT HANKERCHIEF TODDLER $24.95 *OUT OF STOCK*	TIGHTS CHILD BLCKG 12 TO 14 $3.95
TIGHTS CHILD GRNG 12 TO 14 $3.95	TIGHTS CHILD REDRG 12 TO 14 $3.95	TIGHTS CHILD SEAMLESS $12.95 *OUT OF STOCK*
TIGHTS FOOTLESS CHILD $16.95 *OUT OF STOCK*	TIGHTS HOLD AND STRETCH CHILD $16.95 *OUT OF STOCK*	TIGHTS MESH CH BLK 12 TO 15 $3.95
TIGHTS TRANSITION CHILD $18.95 *OUT OF STOCK*	TRUNKS CHILDS NYLON $12.95 *OUT OF STOCK*	UNITARD ANKLE LENGTH CHILD $49.95 *OUT OF STOCK*
UNITARD CHILD 3/4 SLEEVE $77.95 *OUT OF STOCK*

Displaying 1 to 16 (of 16 products)

Result Pages: 1

left start: 0.0407 sec
left end: 0.2341 sec
listing start: 0.2395 sec
listing end: 0.4273 sec
END: 0.4281 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 = '995' or p2c.categories_id = '996' or p2c.categories_id = '997' or p2c.categories_id = '998' or p2c.categories_id = '999' or p2c.categories_id = '1000' or p2c.categories_id = '1001' ) group by products_id_group order by p.description