/home/goldend1/public_html/crossbow.php 157
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p2c.category_id = c.id
                        ANd c.is_show = 1) a, 
      ' at line 5

SELECT a.title category_title, a.id category_id, b.*
              FROM (SELECT c.title, c.id, p2c.product_id
                      FROM categories c, product2category p2c
                      WHERE c.parent =
                        AND p2c.category_id = c.id
                        ANd c.is_show = 1) a, 
                   (SELECT p2c.id item_id,
                           p.id, 
                           p.title as title, 
                           p.description, 
                           REPLACE(FORMAT(CONVERT(price, UNSIGNED), 0 ), ',', ' ') as price,
                           p.price pr, 
                           CONCAT('images/upload/',REPLACE(p.image,'.jp', '.thumb.jp')) as image,
                           image_x+8 image_x, image_y+9 image_y,
                           p2c.sort,
                           b.id brand_id,
                           b.title brand_title,
                           b.url brand_url,
                           b.image brand_image
                      FROM products p, product2category p2c, categories c, brands b, product2brand p2b               
                      WHERE c.id =  
                       AND p2c.category_id = c.id
                       AND c.is_show = 1
                       AND p.id = p2c.product_id
                       AND p.id = p2b.product_id
                       AND b.id = p2b.brand_id
                       AND p.id IN (SELECT product_id
                                      FROM product2brand
                                      WHERE brand_id = 20 OR 20 = 0)) b
              WHERE a.product_id = b.id
              ORDER BY a.id, b.pr ASC