1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Zencart guru wanted!!!

Discussion in 'Hire a Freelancer' started by mobai, Jul 3, 2010.

  1. mobai

    mobai Junior Member

    Joined:
    Jun 23, 2010
    Messages:
    142
    Likes Received:
    6
    I need a zencart guru to help adapt my MYSQL. My site always got throttled and the server supplier said it was because my MYSQL's bad queries. Here is the info. they offered. Pls check and PM me if you could help!!!

    bad queries such as this: select p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products _quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_de script ion, IF(s.status = 1, s.specia ls_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_c all, p.product_is_always_free_shipping, p.products_qty_box_status from products_de script ion pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( p2c.categories_id =1 or p2c.categories_id =7 or p2c.categories_id =184 or p2c.categories_id =185 or p2c.categories_id =186 or p2c.categories_id =187 or p2c.categories_id = 188 or p2c.categories_id =189 or p2c.categories_id =190 or p2c.categories_id =191 or p2c.categories_id =192 or p2c.categories_id =156 or p2c.categories_id =193 or p2c.categories_i d =194 or p2c.categories_id =195 or p2c.categories_id =196 or p2c.categories_id =197 or p2c.categories_id =164 or p2c.categories_id =167 or p2c.categories_id =168 or p2c.categorie s_id =169 or p2c.categories_id =170 or p2c.categories_id =171 or p2c.categories_id =172 or p2c.categories_id =173 or p2c.categories_id =174 or p2c.categories_id =175 or p2c.categories_id =176 or p2c.categories_id =177 or p2c.categories_id =178 or p2c.categories_id =769 or p2c.categories_id =179 or p2c.categories_id =181 or p2c.categories_id =182 or p2c.categories_id =183 or p2c.categories_id =2 or p2c.categories_id =18 or p2c.categories_id =198 or p2c.categories_id =199 or p2c.categories_id =19 or p2c.categories_id =20 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =200 or p2c.categories_id =201 or p2c.categories_id =202 or p2c.categories_id =203 or p2c.categories_id =204 or p2c.categories_id =150 or p2c.categories_id =151 or p2c.categories_id =205 or p2c.categories_id =206 or p2c.categories_id =207 or p2c.categories_id =152 or p2c.categories_id =153 or p2c.categories_id =154 or p2c.categories_id =155 or p2c.categories_id =208 or p2c.categories_id =209 or p2c.categories_id =3 or p2c.categories_id =775 or p2c.categories_id =776 or p2c.categories_id =812 or p2c.categories_id =817 or p2c.categories_id =821 or p2c.categories_id =21 or p2c.categories_id =141 or p2c.categories_id =259 or p2c.