EXPLAIN SELECT c.comment, c.date1, c.id, c.title, ph.value, ph.cid, 
                     b.summa1, b.summa2, b.summa3, b.summa4, (b.summa1 + b.summa2 - b.summa3 - b.summa4) AS balance, 
                     b.yy, b.mm, tp.title AS tariff, opva.address AS obj_addr, c.status 
                     FROM contract c, contract_parameter_type_phone ph, contract_balance b, 
                     tariff_plan tp, contract_tariff ct, object o, object_param_value_address opva 
                     WHERE c.title LIKE '101%' 
                     AND c.id = ph.cid AND c.id = b.cid AND c.fc = 0
                     AND o.cid = c.id AND opva.object_id = o.id AND tp.id = ct.tpid 
                     AND ct.cid = c.id ORDER BY title

CREATE INDEX index_cid ON contract_parameter_type_phone (cid);

CREATE TABLE bgbilling.contract (
  id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  gr bigint(20) NOT NULL DEFAULT 0,
  title varchar(150) NOT NULL DEFAULT '',
  title_pattern_id int(11) NOT NULL DEFAULT 0,
  pswd varchar(32) NOT NULL DEFAULT '',
  date1 date DEFAULT NULL,
  date2 date DEFAULT NULL,
  mode tinyint(4) NOT NULL DEFAULT 0,
  closesumma decimal(10, 2) NOT NULL,
  pgid int(11) NOT NULL DEFAULT 0,
  pfid int(11) NOT NULL DEFAULT 0,
  fc tinyint(1) NOT NULL DEFAULT 0,
  comment varchar(100) NOT NULL DEFAULT '',
  del tinyint(1) NOT NULL DEFAULT 0,
  scid int(11) NOT NULL DEFAULT 0,
  sub_list text NOT NULL,
  sub_mode tinyint(4) NOT NULL DEFAULT 0,
  status tinyint(4) NOT NULL DEFAULT 0,
  status_date date DEFAULT NULL,
  last_tariff_change datetime DEFAULT NULL,
  crm_customer_id int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  INDEX crm_customer_id (crm_customer_id),
  INDEX crm_id (crm_customer_id),
  INDEX date1 (date1),
  INDEX del (del),
  INDEX scid (scid),
  INDEX title (title)
)
ENGINE = MYISAM
AUTO_INCREMENT = 23056
AVG_ROW_LENGTH = 71
CHARACTER SET cp1251
COLLATE cp1251_general_ci;