Dot Line Corp

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (10198, 17606, 184751, 14138, 14139, 14398, 14465, 15241, 15242, 15243, 15244, 13010, 13011, 13012, 13088, 13483, 13484, 13485, 7054, 7266, 8520, 8859, 8860, 8861, 11890, 11891, 11892, 11893, 11894, 11895)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,10198,17606,184751,14138,14139,14398,14465,15241,15242,15243,15244,13010,13011,13012,13088,13483,13484,13485,7054,7266,8520,8859,8860,8861,11890,11891,11892,11893,11894,11895)
View as Grid List

Items 1-30 of 103

Page
per page
Set Ascending Direction
  1. Male PC to Male PC Cord (1')
    Dot Line Corp Male PC to Male PC Cord (1')
    USD $7.95
    SKU: DOT-01144
    Model: DL-1531
    Condition: New-In-Box
  2. Dot Line Corp Hot Shoe-Tripod Mt PC
    USD $15.95
    SKU: DOT-01124F
    Model: DL-0418
    Condition: New-In-Box
  3. LED Slide Viewer
    Dot Line Corp LED Slide Viewer
    USD $39.99
    SKU: DOT-01249
    Model: DL-SV3
    Condition: New-In-Box
  4. DLC 47" Camera Slider
    Dot Line Corp DLC 47" Camera Slider
    USD $179.95
    Out of stock
    SKU: DOT-01247
    Model: DL-SLD47
    Condition: New-In-Box
  5. iPhone Pod with LED Kit
    Dot Line Corp iPhone Pod with LED Kit
    USD $83.95
    Out of stock
    SKU: DOT-01124W
    Model: DL-0903
    Condition: New-In-Box
  6. RPS Studio 4' Articulating Arm
    Dot Line Corp RPS Studio 4' Articulating Arm
    USD $92.95
    Out of stock
    SKU: DOT-02335
    Model: RS-5056
    Condition: New-In-Box
  7. DV112 Video and DSLR Li-Ion Video Light
    Dot Line Corp DV112 Video and DSLR Li-Ion Video Light
    USD $119.95
    Out of stock
    SKU: DOT-01221
    Model: DL-DV112
    Condition: New-In-Box
  8. DL-1580
    SKU: DOT-01149P
    Model: DL1580
    Condition: New-In-Box
  9. DL-1582
    SKU: DOT-01149R
    Model: DL1582
    Condition: New-In-Box
  10. DL-1586
    Dot Line Corp Programmable Interval Timer for Nikon D800, D4 (10 Pin)
    USD $49.95
    Out of stock
    SKU: DOT-01149T
    Model: DL1586
    Condition: New-In-Box
  11. DL-1588
    Dot Line Corp Programmable Interval Timer for Nikon 90, D5100, D7000
    USD $49.95
    Out of stock
    SKU: DOT-01149V
    Model: DL1588
    Condition: New-In-Box
  12. Dot Line Corp Video and DSLR LED Li-Ion Light
    USD $189.95
    Out of stock
    SKU: DOT-01223
    Model: DL-DV256
    Condition: New-In-Box
  13. Pico Dolly with Pouch
    Dot Line Corp Pico Dolly with Pouch
    USD $69.99
    Out of stock
    SKU: DOT-01510
    Model: PC-PD1
    Condition: New-In-Box
  14. DLC Skater Dolly
    Dot Line Corp DLC Skater Dolly
    USD $199.97
    Out of stock
    SKU: DOT-01234
    Model: DL-SKATER
    Condition: New-In-Box
  15. Dot Line Corp Contact Cleaner
    USD $19.97
    Out of stock
    SKU: DOT-04000
    Model: HA-5629
    Condition: New-In-Box
  16. Pico Dolly Kit
    Dot Line Corp Pico Dolly Kit
    USD $99.95
    Out of stock
    SKU: DOT-01511
    Model: PC-PD/KIT
    Condition: New-In-Box
  17. RPS Studio DSLR Rig
    Dot Line Corp RPS Studio DSLR Rig
    USD $79.97
    Out of stock
    SKU: DOT-02020
    Model: RS-0400
    Condition: New-In-Box
  18. Dot Line Corp DSLR Cleaning Kit
    USD $19.97
    Out of stock
    SKU: DOT-01153
    Model: DL-4410P
    Condition: New-In-Box
  19. Dot Line Corp Carry Case f/3 Studio Srobes
    USD $141.95
    Out of stock
    SKU: DOT-02235
    Model: RS-3172
    Condition: New-In-Box
  20. Dot Line Corp Posing Stool
    USD $99.95
    Out of stock
    SKU: DOT-02340
    Model: RS-6000
    Condition: New-In-Box
  21. SKU: DOT-02390
    Model: RS-HCSET
    Condition: New-In-Box
  22. Dot Line Corp Tilt Bracket with 1/4x20 Posts
    USD $45.95
    Out of stock
    SKU: DOT-01216
    Model: RS-3100
    Condition: New-In-Box
  23. Tilt Bracket with 4 Accessories Shoes
    Dot Line Corp Tilt Bracket with 4 Accessories Shoes
    USD $68.95
    Out of stock
    SKU: DOT-01217
    Model: RS-3102
    Condition: New-In-Box
  24. Dot Line Corp LED Light
    USD $119.95
    Out of stock
    SKU: DOT-01244
    Model: DL-SL60
    Condition: New-In-Box
  25. Dot Line Corp EPC 30 Watt CFL 5500K Bulb
    USD $11.97
    Out of stock
    SKU: DOT-10110
    Model: EPC-CFL30W
    Condition: New-In-Box
  26. Dot Line Corp EPC 35 Watt CFL 5500K Bulb
    USD $13.97
    Out of stock
    SKU: DOT-10112
    Model: EPC-CFL35W
    Condition: New-In-Box
  27. Dot Line Corp EPC 45 Watt CFL 5500K Bulb
    USD $21.97
    Out of stock
    SKU: DOT-10114
    Model: EPC-CFL45W
    Condition: New-In-Box
  28. Dot Line Corp EPC 70 Watt CFL 5500K Bulb
    USD $31.97
    Out of stock
    SKU: DOT-10116
    Model: EPC-CFL70W
    Condition: New-In-Box
  29. Dot Line Corp EPC 105 Watt CFL 5500K Bulb
    USD $44.97
    Out of stock
    SKU: DOT-10118
    Model: EPC-CFL105W
    Condition: New-In-Box
  30. Dot Line Corp EPC 150 Watt CFL 5500K Bulb
    USD $59.97
    Out of stock
    SKU: DOT-10120
    Model: EPC-CFL150W
    Condition: New-In-Box
View as Grid List

Items 1-30 of 103

Page
per page
Set Ascending Direction