SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (504, 505, 260, 264, 279) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 5,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (504,505,260,264,279)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
260 <p><span style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional &quot;Ball Head&quot; </span></p> <p>Professionals demand a device that can trust.</p> <p>It must perform when situation gets difficult, even in extreme cold or hot weathers.</p> <p>Our Q-Balls are very durable and corrosion resistant because they are made out of the highest quality Material(A6061-T6) used in the aviation industry with CNC precision machining and hard-anodized process.</p> <p>You can trust our Q-Ball and dedicated yourself in taking pictures.</p> <p><br> →　<a href="./about-markins#movie"><strong>Demo Movie (9kg TEST BAR on Markins Q10i)</strong></a></p> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <ul> <li>All-in-one design with quickshoe</li> <li>100lb (45kg) of load capacity, the best in its class</li> <li>Compatible with the new BV-Head attachment</li> <li>Improved anti-vibration and new replaceable quickshoe connection</li> <li>The new Quick-Turn knob opens or closes by one turn (Patented)</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Turn Knob</div> It only takes a single turn to open or close the quickshoe jaw. You will appreciate this fast open and close performance when you need to change the setup quickly, especially in cold weather or under urgent situation. <br> <br> <p><img src="./html/images/qs-i-type-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Posision Marks</div> Laser engraved position marks make it convenient to align the nodal point in panorama photography.<br> <br> <p><img src="./html/images/qs-i-type-index-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="100%" cellpadding="5" cellspacing="1"> <tbody> <tr><td><div align="center"><strong>Code</strong></div></td> <td><strong>Q10i-RD</strong></td> </tr> <tr><td><div align="center">Color</div></td> <td>Wine Red </td> </tr> <tr><td><div align="center">Maximum Load</div></td> <td>100lb (45 kg)</td> </tr> <tr><td><div align="center">Weight</div></td> <td>1.10lb (498 g)</td> </tr> <tr><td><div align="center">Ball Diameter</div></td> <td>1.73in (44mm)</td> </tr> <tr><td><div align="center">Base Diameter</div></td> <td>2.44in (62mm)</td> </tr> <tr><td><div align="center">Height</div></td> <td>3.86in (98mm)</td> </tr> <tr><td><div align="center">Tripod Mount Hole</div></td> <td>UNC 3/8&quot;-16</td> </tr> <tr bgcolor="#424242"> <td nowrap="nowrap" bgcolor="#ffffff"><div align="center">Friction Control</div></td> <td bgcolor="#ffffff"><div align="left">Bi-Axial Progressive</div></td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Maximum Torque</div></td> <td bgcolor="#ffffff"><div align="left">200 lbf・in (225 kgf・cm)</div></td> </tr> <tr><td><div align="center">Panning</div></td> <td>Yes</td> </tr> <tr><td><div align="center">Panorama Index </div></td> <td>Yes</td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Camera Connection</div></td> <td bgcolor="#ffffff"><div align="left">Screw Knob Style Quickshoe (<a href="/quickshoe/qr60i/">QR-60i</a>)</div></td> </tr> </tbody> </table> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba Fine Art Quality, Professional Ball Head Markins Q10i-RD Knob Shoe
264 <p><span style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional &quot;Ball Head&quot; </span></p> <p>Professionals demand a device that can trust.</p> <p>It must perform when situation gets difficult, even in extreme cold or hot weathers.</p> <p>Our Q-Balls are very durable and corrosion resistant because they are made out of the highest quality Material(A6061-T6) used in the aviation industry with CNC precision machining and hard-anodized process.</p> <p>You can trust our Q-Ball and dedicated yourself in taking pictures.</p> <p><br> →　<a href="./about-markins#movie"><strong>Demo Movie (9kg TEST BAR on Markins Q10i)</strong></a></p> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <ul> <li>All-in-one design with quickshoe</li> <li>110lb (50kg) of load capacity, the best in its class</li> <li>Compatible with the new BV-Head attachment</li> <li>Improved anti-vibration and new replaceable quickshoe connection</li> <li>The new Quick-Turn knob opens or closes by one turn (Patented)</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Turn Knob</div> It only takes a single turn to open or close the quickshoe jaw. You will appreciate this fast open and close performance when you need to change the setup quickly, especially in cold weather or under urgent situation. <br> <br> <p><img src="./html/images/qs-i-type-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Posision Marks</div> Laser engraved position marks make it convenient to align the nodal point in panorama photography.<br> <br> <p><img src="./html/images/qs-i-type-index-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="100%" cellpadding="5" cellspacing="1"> <tbody> <tr><td><div align="center"><strong>Code</strong></div></td> <td><strong>Q20i-RD</strong></td> </tr> <tr><td><div align="center">Color</div></td> <td>Wine Red </td> </tr> <tr><td><div align="center">Maximum Load</div></td> <td>110lb (50 kg)</td> </tr> <tr><td><div align="center">Weight</div></td> <td>1.22lb (553 g)</td> </tr> <tr><td><div align="center">Ball Diameter</div></td> <td>1.89in (48mm)</td> </tr> <tr><td><div align="center">Base Diameter</div></td> <td>2.68in (68mm)</td> </tr> <tr><td><div align="center">Height</div></td> <td>4.02in (102mm)</td> </tr> <tr><td><div align="center">Tripod Mount Hole</div></td> <td>UNC 3/8&quot;-16</td> </tr> <tr bgcolor="#424242"> <td nowrap="nowrap" bgcolor="#ffffff"><div align="center">Friction Control</div></td> <td bgcolor="#ffffff"><div align="left">Bi-Axial Progressive</div></td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Maximum Torque</div></td> <td bgcolor="#ffffff"><div align="left">220 lbf・in (250 kgf・cm)</div></td> </tr> <tr><td><div align="center">Panning</div></td> <td>Yes</td> </tr> <tr><td><div align="center">Panorama Index </div></td> <td>Yes</td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Camera Connection</div></td> <td bgcolor="#ffffff"><div align="left">Screw Knob Style Quickshoe (<a href="/quickshoe/qr60i/">QR-60i</a>)</div></td> </tr> </tbody> </table> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba Fine Art Quality, Professional Ball Head Markins Q20i-RD Knob Shoe
279 <p>Dovetail type lever release clamp with a spring loaded detent pin to prevent from accidental slippage. Compatible with any Arca-Swiss type camera plates from Arca, Foba, Kirk and R.R.S.</p> <div id="separate_dot_bar"></div> <div style="width:300px; float:left;"> <img src="./images/detailed/1/ql60i-01.jpg"> </div> <div style="width:300px; float:left;"> <img src="./images/detailed/1/ql60i-02.jpg"> </div> <div style="clear:both;"></div> <div id="separate_dot_bar"></div> <ul style="margin-left:0px; padding-left:30px;"> <li><strong><em>Easy Opening and Closing:</em></strong> The quickshoe opens/closes fully in one quick lever action even with hand with glove on.</li> <li><strong><em>Adjustable Clamping Distance (Patented):</em></strong> The clamping distance is user-adjustable by turning the adjustment screw for plates larger than Markins standard such as Kirk or RRS.</li> <li><strong><em>Convertible Lever Arm Position (Patented):</em></strong> The lever arm is convertible to either left or right hand position for one's own convenience.</li> <li><strong><em>Protected Lever Cam Mechanism (Patented):</em></strong> The lever cam mechanism is embedded inside of the quickshoe, which vastly reduces the chance that the lever mechanism could be damaged by accidental impact.</li> <li><strong><em>Compact Design:</em></strong> The lever arm stays compact either opened or closed position.</li> <li>Laser engraved position marks.</li> <li>Built-in spirit level for leveling.</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">for Markins i-Type Ball Head</div> <p><img src="./html/images/i-type-shoe.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Release Lever</div> The lever arm is convertible to eigher left or right hand position for one's own convenience.<br> <br> <p><img src="./html/images/qs-i-type-q-en.gif" ></p> <div id="separate_dot_bar"></div> <div style="width:150px;float:left; margin:0 10px 10px 0;"><img src="./html/items/01_opening.gif"></div> <div style="width:150px;float:left; margin:0 10px 10px 0;"><img src="./html/items/02_adjustment.jpg"></div> <div style="width:150px;float:left; margin:0 10px 10px 0;"><img src="./html/items/03_lr_change.gif"></div> <div style="clear:both;"></div> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Posision Marks</div> Laser engraved position marks make it convenient to align the nodal point in panorama photography.<br> <br> <p><img src="./html/images/qs-index-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td width="30%" bgcolor="#FFFFFF"><div align="center"><strong>Code</strong></div></td> <td width="70%" bgcolor="#FFFFFF"><strong>QL60i</strong></td> </tr> <tr> <td nowrap bgcolor="#FFFFFF"><div align="center">Release Style</div></td> <td nowrap bgcolor="#FFFFFF">Lever Release Style</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Jaw Length</div></td> <td bgcolor="#FFFFFF">2.36 in (60mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Height</div></td> <td bgcolor="#FFFFFF">0.59 in (15mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Weight</div></td> <td bgcolor="#FFFFFF">3.46 oz (98ｇ)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Material</div></td> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Mounting Bolt </div></td> <td bgcolor="#FFFFFF"><strong><a href="/accessory/m6bt/">M6 Bolt</a></strong> *not included in the price</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Target Products </div></td> <td bgcolor="#FFFFFF">Markins i-Type Ball Head <strong>Q10i &amp; Q20i series</strong></td> </tr> </table> <br> <div id="separate_dot_bar"></div> <p><br> </p>
504 <!-- <div style="color:red; font-size:14px;margin-top:10px;"> 初期入荷数は限られておりますので、お早めにご注文下さい！ </div> <div id="separate_dot_bar"></div> --> <div style="font-size:14px;font-weight:bold;"> <p>マーキンス LC-542 は、キヤノン EOS 5D Mark IV 用 サブプレートです。</p> </div> <div> カメラプレート <b>PC-542</b> と組み合わせることにより、縦位置撮影に素早く変更できる L-プレート（L型ブラケット）としてご使用になれます。 </div> <div id="separate_dot_bar"></div> <div style="font-size:14px; margin-bottom:20px;"> EOS 5D Mark IV 用のL-プレートは一体型の <b>LC-540</b> と カメラプレートPC-542と組み合わせて使用する サブプレート <b>LC-542</b> の２種類が発表されましたので、下記表をご参照の上お選び下さい。</div> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td bgcolor="#FFFFFF" align="center"><b>モデル</b></td> <td bgcolor="#FFFFFF" align="center"><b>LC-540</b></td> <td bgcolor="#FFFFFF" align="center"><b>PC-542 + LC-542</b></td> </tr> <tr> <td bgcolor="#FFFFFF" align="center"><b>タイプ</b></td> <td bgcolor="#FFFFFF" align="center">一体型</td> <td bgcolor="#FFFFFF" align="center">組み合わせ型</td> </tr> <tr> <td bgcolor="#FFFFFF" align="center"><b>装着方向</b></td> <td bgcolor="#FFFFFF" align="center">両方向</td> <td bgcolor="#FFFFFF" align="center">単一方向</td> </tr> <tr> <td bgcolor="#FFFFFF" align="center"><b>レリーズケーブル装着</b></td> <td bgcolor="#FFFFFF" align="center">スライドにより可能</td> <td bgcolor="#FFFFFF" align="center">可能</td> </tr> </table> <!-- <p>（カメラプレートは <a href="/plate/camera/p53u"><strong>P53U</strong></a>、バッテリーグリップ BG-E11用のプレートは <a href="/plate/camera/pg50"><strong>PG-50</strong></a> です。）<br /> </p> --> <div id="separate_dot_bar"></div> <br> <p> L-プレートは、正位置でのみ雲台に装着できるカメラプレートに対して、縦位置でも正位置でも装着できるＬ型のプレートです。</p> <p>カメラプレートで縦位置にする場合、雲台を90度傾ける必要がありますが、L-プレートの場合は雲台を傾けるかわりにカメラを縦位置にして雲台に装着し直します。</p> <p>雲台を90度傾けますと、カメラやレンズの重心が三脚の中心軸から横にそれることになりますので、機材の重量に比例して三脚の安定性は低下します。</p> <p>また光軸がズレますと、構図を決めなおさなければいけませんので、水平取りや位置合わせなど思いのほか時間がかかってしまいます。</p> <p>これらのことからL-プレートの利便性についてご理解頂けたと思いますが、カメラやレンズ同様、満足のいく一枚を撮る為に何年も使い続けるものですので、こだわりのあるしっかりしたものをお選びください。</p> <p>マーキンスのL-プレートは、航空機の素材としても使用される軽量で強固なアルミ合金を削り出し、バレル研磨の後、高度の硬質アルマイト加工を施しますので、表面が非常になめらかでかつ耐摩耗性にずば抜けています。</p> <p>また、線や面のとりかたが非常に美しく繊細ながらもシンプルで、軽量化・安定化のためのさまざまな設計ノウハウが反映されております。</p> <p>軽いのに機材をしっかりとホールドし、ブレのない安定した撮影をサポートするのがマーキンスの特性です。</p> <br> <div id="separate_dot_bar"></div> <ul> <li>アルカスイスと互換性のあるダブテールスタイル</li> <li>Anti Twist Flange 構造により、カメラとの安全な結合を維持</li> <li>硬質アルマイト（ハードアノダイジン）加工による高い耐磨耗性</li> <li>滑らかで安全なラウンド加工</li> <li>高級感のある艶消し仕上げ</li> </ul> <br> <br> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">メーカー</th> <td bgcolor="#FFFFFF">マーキンス（Markins）</td> </tr> <tr> <th bgcolor="#FFFFFF">型番</th> <td bgcolor="#FFFFFF">LC542</td> </tr> <tr> <th bgcolor="#FFFFFF">重量</th> <td bgcolor="#FFFFFF">30 g / 86 g （組み合わせ）</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">サイズ</th> <td bgcolor="#FFFFFF">19×38×82 mm / 108×50×82 mm （組み合わせ）</td> </tr> <tr> <th bgcolor="#FFFFFF">材質</th> <td bgcolor="#FFFFFF">アルミ合金　A6061-T6</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">装着方法</th> <td bgcolor="#FFFFFF">1/4 UNC（細）ネジ<BR> ※別売の <strong><A href="./accessory/tllw1">L型六角レンチ（4mm）</A></strong> にて装着</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">付属</th> <td bgcolor="#FFFFFF"><a href="./accessory/hb1"><strong>1/4 UNC（細）ネジ</strong></a> × １</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">主な適応カメラ</th> <td bgcolor="#FFFFFF">キヤノン EOS 5D Mark IV</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">発売日</th> <td bgcolor="#FFFFFF">2016年 10月28日</td> </tr> </table> <br> <div id="separate_dot_bar"></div> <br> <!-- <div align="center"><img src="/html/items/lc542/lc542_body_10.jpg"></div> <div style="height:10px;"></div> <div align="center"><img src="/html/items/lc542/lc542_body_11.jpg"></div> <div style="height:10px;"></div> <div align="center"><img src="/html/items/lc542/lc542_body_12.jpg"></div> <div style="height:10px;"></div> <div align="center"><img src="/html/items/lc542/lc542_body_20.jpg"></div> <div style="height:10px;"></div> <div align="center"><img src="/html/items/lc542/lc542_body_21.jpg"></div> <br> --> <div style="text-align:center;"></div> <!-- <div id="separate_dot_bar"></div> <div style="width:96%;text-align: left;">サイトリンク：　<a href="http://ganref.jp/accessories/2553/spec">GANREF</a></div> --> <br> <br> <br>