select count(p.products_id) as total from products p inner join products_description pd on p.products_id = pd.products_id where pd.products_name LIKE 'a%' === 0.067974805831909 === /index.php === /canada-laptop-batteries/a/66.html
select p.`products_id`,pd.`products_name` FROM (SELECT products_id FROM products_description where products_name like 'a%' ORDER BY products_id desc limit 6500, 100) AS tmp INNER JOIN products p ON tmp.products_id = p.products_id ,products_description pd where p.`products_id` = pd.`products_id` AND pd.`products_name` LIKE 'a%' limit 100 === 0.022868156433105 === /index.php === /canada-laptop-batteries/a/66.html
Canada Battery Store: Aec657987 battery store, rtdpart 7.6V 41.8Wh batteries for
Shopping Cart
0 item(s) - C$0.00
ProductBanner_1
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 0-9
select count(p.products_id) as total from products p inner join products_description pd on p.products_id = pd.products_id where pd.products_name LIKE 'a%' === 0.054650068283081 === /index.php === /canada-laptop-batteries/a/66.html
 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
 141 142 143 144 145 146 147 148 149 150 151 152 153 154

Disclaimer:
The information on this website contains certain brand trademarks, which is solely to show that our products are compatible with this brand, the trademarks belong to the original registered brands
Parse Time: 0.317 - Number of Queries: 572 - Query Time: 0.2961151599884